Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting numbers with two decimals
Good Morning!
I searched through some previous posts and found some interesting answers to different sorting questions, however, I could not find one exactly similar to my situation. I need to sort the following list: 12345.01 20052.01 12345.02.02 17789.02 17789.01 12345.01.03 12345.02 Excel sorts as follows: 12345.01 12345.02 17789.01 17789.02 20052.01 12345.01.03 12345.02.02 This would need to show in the following order: 12345.01 12345.01.03 12345.02 12345.02.02 17789.01 17789.02 20052.01 I understand the reason why I'm getting a funky sort is because the items with two decimal points are being treated as text while the others are being treated as numbers. One way I believe I got Excel 2003 to sort properly was to create a new column, format it to be text (Format Cells Text), then paste the row into the row that was previously formatted as text. My data is saved from a sourse as a .csv file. I tried importing the data, but it still treated some numbers as text. Any ideas? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing whole numbers into decimals | Excel Worksheet Functions | |||
Sorting Decimals as Numbers | Excel Discussion (Misc queries) | |||
Sorting Numbers with Multiple Decimals (cont.) | Excel Discussion (Misc queries) | |||
Sorting Numbers with Multiple Decimals | Excel Discussion (Misc queries) | |||
Excel: How can I get numbers without decimals ? | New Users to Excel |