Precede the numbers with an apostrophe like

'007 '0245 '052

DataSort

"Sort anything that looks like a number, as a number"


Gord Dibben MS Excel MVP

On Thu, 01 Apr 2010 07:39:50 -0700, Anita Marlay wrote:

I have a list of various numbers and text that I want to sort numerically. Here is an example:
T300
D9745
P50
565
007
0245
052

Problems: 1.Getting leading zeros to show AND be recognized.
2. Sorting--when I try to sort, it will sort like 7,52, 245, 565, P50, T300, D9745. I want it to sort numerically first (007,0245,052,565) then alphabetically (D9745,P50, T300).
I'm assuming this is impossible, but any tips would be appreciated.


Submitted via EggHeadCafe - Software Developer Portal of Choice
Break the Roles in SharePoint Lists
http://www.eggheadcafe.com/tutorials...in-sharep.aspx