Formula Advice on Sorting Decimal Values from lowest value to Highest value

[VBA learner ITG]

Hi Peers,

I appreciate this may have been asked before but i am having issues sorting values with decimal points from low to high.

In Column A I have decimal values and in column B i have applied this formula to help with the sortation: =INT(A2)&"."&TEXT(RIGHT(A2,LEN(A2)-(FIND(".",A2))),"000")

The issue it is having is when the value is for example 1.10 it shows thew value as 1.001 when it should be 1.010

Any advice appreciated on how to resolve my issue?

CUSTOMER SEQUENCE	SORT SEQUENCE WITH FORMULA
1.1	1.001
1.2	1.002
1.3	1.003
1.4	1.004
1.5	1.005
1.6	1.006
1.7	1.007
1.8	1.008
1.9	1.009
1.1	1.001
1.11	1.011
1.12	1.012
1.13	1.013
1.14	1.014
1.15	1.015
1.16	1.016
1.17	1.017
1.18	1.018
1.19	1.019
1.2	1.002

 

[mikerickson]

If you want them to be different then you have to format the column as text.
Or use a mathematically correct notation as others have suggested, where the value after 1 is 1.01, etc.

 

[VBA learner ITG]

Thank you everyone for taking the time to help me i have formatted the column as Text which works.