
Frans Visser
Duivendrecht (near Amsterdam) - The Netherlands
VIP
Members

Forum Posts: 346
Member Since:
April 21, 2015
April 21, 2015


Mynda Treacy
Admin

Forum Posts: 4513
Member Since:
July 16, 2010
July 16, 2010

Hi Jim,
If the numbers are formatted as Numbers then they will sort correctly. It looks like your source data is formatted as text, hence the sorting problem. If you can't change the format to numbers, then the other solution is to add a leading space in front of the numbers less than 10. This leading space tip was shared with my by fellow Excel MVP, Ingeborg Hawighorst.
Mynda
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Geoff McClure, Riny van Eekelen, David Jernigan, Cassie Bernier
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 215
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Abisola Ogundele
MARTYN STERRY
Rahim Lakhani
Ngoc Qui Nguyen
Clement Mansfield
Rose .
Bindu Menon
Baruch Zemer
Purple RainbowBenefactor
MOTH Junkie
Forum Stats:
Groups: 3
Forums: 24
Topics: 6350
Posts: 27773
Member Stats:
Guest Posters: 49
Members: 32317
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
