Sorting numbers in a col

ironsides

Well-known Member
Joined
Aug 12, 2002
Messages
575
When sorting numbers in a col, they come out 1, 10, 11, 2,3,4,5,6,7,8,9. How can I make them come out 1,2,3,4,5,6,7,8,9,10,11? Thank you, Ironsides
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,086
Office Version
  1. 365
Platform
  1. Windows
Ironsides

Sounds to me that Excel isn't actually recognising the values as numbers.

Where are the numbers coming from?
 

ironsides

Well-known Member
Joined
Aug 12, 2002
Messages
575
thanks Norie, of course, the col was Text not number. Changing it to number fixed it. ( blush blush blush )
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,086
Office Version
  1. 365
Platform
  1. Windows
Glad it was that simple.:)

Thought we might end up in some long, contracted thread.:)
 

Watch MrExcel Video

Forum statistics

Threads
1,119,137
Messages
5,576,299
Members
412,716
Latest member
Ardin
Top