VBA learner ITG
Active Member
- Joined
- Apr 18, 2017
- Messages
- 267
- Office Version
- 365
- Platform
- Windows
- MacOS
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?
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 |