Tech Support Forum - View Single Post

Net75 · 06-28-2009, 05:45 PM

Hi does anyone know how I can sort in excel by leading digit - not by the entire string?

I have tried formatting the list of digits as text, but excel still sorts numerically...

I have a list of 1500 recirds that I need to to sort to look like:

10522
110400
12983
150660
17575

Thanks

06-28-2009, 05:45 PM	#1 (permalink)
Net75 Registered User Join Date: Jun 2009 Posts: 1 OS: XP	Sort by leading digit in Excel Hi does anyone know how I can sort in excel by leading digit - not by the entire string? I have tried formatting the list of digits as text, but excel still sorts numerically... I have a list of 1500 recirds that I need to to sort to look like: 10522 110400 12983 150660 17575 Thanks