Sort "text" numbers with and without leading zeros as numbers

  • Thread starter Thread starter T.K.
  • Start date Start date
T

T.K.

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?
 
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
 
Back
Top