Excel sorting numbers

[romantzlady]

I have a lot of documents where I have to sort numbers.  I've had no problems with my sort until I updated my office program 3 weeks ago.  Now with every number grouping I sort it gives me an inaccurate sort.  Is this something that I can change?

This is what it should be:

what I		how it
want		sorts
1		1
2		10
3		11
4		12
5		13
6		14
7		2
8		3
9		4
10		5
11		6
12		7
13		8
14		9

[#2]

Please upload/share the Workbook to examine the data, otherwise difficult to say the reason!!

[#3]

@romantzlady Can't explain why this started after an update, but your "numbers" are in fact texts and sorted accordingly. Use the VALUE function to convert them to numbers.

[#4]

@romantzlady 

Most probably you have texts, not numbers. With that to sort click on

Here is like

and next it asks you

Select Sort as numbers.