Excel Number Sorting

  • Thread starter Thread starter Adam Rothschild
  • Start date Start date
A

Adam Rothschild

I have imported some data into excel as text because if I
do so as general, excel chops off some zero's placed after
decimal points. (for example 151.0 151.00) I need those
zero's to stay. Then once the data is imported correctly
under text I want to change them back to a number format
and sort the numbers like 151 151.0 151.00, etc. Instead
excel sorts like this 151 151.9 151.8 151.7 151.6 151.5
151.4 151.3 151.2 151.1 151.0 15.9 15.8 15.7 15.6, etc.
Skipping from 151 to 15! This number is only an example.
It occurs with all my numbers in the spreadsheet. Any help
is greatly appreciated.
 
Hi
I wouldn't convert to text and back to numbers. Why not use a format
like
0.00
to have a fixed number of decimals
 
Adam

Excel isn't cutting off decimal places, it just doesn't display them. As
always, it is trying to be helpful. As far as Excel is concerned 151 =
151.0 = 151.00.

If you import the data as numeric and you format all the cells with two
decimal places, you will be able to do a numeric sort and see the numbers
correctly.

Regards

Trevor
 
We do not have the option of importng the data a numeric.
Is there another way? We only have general, text, and date.
Thanks for the advice.
 
Back
Top