I am trying to achieve the ff.
I want to add 'K' to the single digit ONLY.
I want to achieve this by using 'IF' on the formula but I do not know how to identify if a digit has a (decimal)point or not.
What formula/condition should I use to identify if the ItemNo has decimal point in it or none?
Thanks in advance!