Excel Number Sorting

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

--
Regards
Frank Kabel
Frankfurt, Germany
"Adam Rothschild" schrieb im Newsbeitrag
...
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.

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


"Adam Rothschild" wrote in message
...
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.

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.
-----Original Message-----
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


"Adam Rothschild" wrote in message
...
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
import the data as 'General' and apply the format afterwards

--
Regards
Frank Kabel
Frankfurt, Germany
"adam" schrieb im Newsbeitrag
...
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.
-----Original Message-----
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


"Adam Rothschild" wrote in message
...
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.


.