I have a list of numbers that I need to remove the leading zeros and still keep the "other" zeros.
The column on the left is my original data, the one on the right is after using formatting, special .000, obviously this does not work.
An example;
0.71 .710 here I need to remove 0 prior to decimal without adding a 0 after the 1
0.74 .740 here I need to remove 0 prior to decimal without adding a 0 after the 4
0.863 .863
0.87 .870 here I need to remove 0 prior to decimal without adding a 0 after the 7
1.058 1.058
1.451 1.451
1.46 1.460 here I do not need to have a 0 after the 6
1.503 1.503
Thank you in advance for any help I can get on this matter.
Bookmarks