Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort "text" numbers with and without leading zeros as numbers
I have a column that contains a mix of numbers with and without leading
numbers. It also contains text. I remember in Excel 2003 it would offer me the option to sort the text numbers as though they were actual numbers. This was really great as I have a sheet that I used to record payment information and I can then sort the payments in true numerical order and quickly go through them in sequence. I can't seem to get Excel 2007 to do the same thing, even when loading the same sheet. Here's an example: 234 0123 CASH 4501 This would sort to: 0123 234 4501 CASH Any ideas? -- TK |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort "text" numbers with and without leading zeros as numbers
If you add a ' before the numbers and sort, that option comes up. Not sure
if that is an answer but I hope it helps "T.K." wrote: I have a column that contains a mix of numbers with and without leading numbers. It also contains text. I remember in Excel 2003 it would offer me the option to sort the text numbers as though they were actual numbers. This was really great as I have a sheet that I used to record payment information and I can then sort the payments in true numerical order and quickly go through them in sequence. I can't seem to get Excel 2007 to do the same thing, even when loading the same sheet. Here's an example: 234 0123 CASH 4501 This would sort to: 0123 234 4501 CASH Any ideas? -- TK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert numbers (ex. "4") to text (ex. "four") | Excel Discussion (Misc queries) | |||
Formating numbers &"Text" to appear as currency &"Text" in formula | Excel Discussion (Misc queries) | |||
Average & median of text "time" numbers | Excel Worksheet Functions | |||
Removing digits after decimal in "text" numbers | Excel Worksheet Functions | |||
sort numbers leading zeros | Excel Discussion (Misc queries) |