| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort Not Working on Column of Numbers
Below is the outcome of my sort when the cells were formatted as number
These are currency values. I copied and pasted the information from a website into Excel and all cells were formatted as "General" when I checked my spreadsheet. I have tried to change the cell formatting to everything imaginable, currency, numbers, removed commas, cleared $ sign formats etc yet it appears that Excel is treating these numbers as text. The help section said to change the cell format to number from text. Yet the data was formatted as "general". It seems to be sorting from the left rather then by total value. 99198 9500 94012 92661 9175 9172 88933 86999 86250 8620 86154 8400 82335 81678 795888 78689 765552 Thanks for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i sort on a perticular column for odd and even numbers | Excel Worksheet Functions | |||
| how do I sort a column mixed with odd and even numbers .. ? | Excel Discussion (Misc queries) | |||
| HOW DO I SORT A COLUMN OF NUMBERS AND HAVE THE DUPLICATES REMOVED | Excel Discussion (Misc queries) | |||
| sort and return column numbers | Excel Worksheet Functions | |||
| sort a column of numbers with 100510 and 10160 so they are in th. | Excel Discussion (Misc queries) | |||
Threaded Mode
