Change A to Z to Smallest to Largest in Excel

[pelozami]

Have numbers in Excel 2016 column that sorts with A to Z instead of smallest. How can I change order from A to Z to smallest to largest?
Cells/columns are defined as a numeric type.


Thanks in advance!

 

[ranman256]

A to Z is = 'smallest to largest'.

 

[ranman256]

if it STILL doesnt sort correctly, then you need to convert the cells. NOT by a format command, that wont work.
make another column to convert the bad column: = value(a2)
then it should sort.

 

[pelozami]

A to Z is = 'smallest to largest'.

Yes, I know
Usually, when you format as number, they are in align right by default, am I right? my column is stored as number and displayed with left align, and thats makes a problem with sorting. By default If you have a numbers in column/rows excel gives you Sort>Order>Smallest to larget. If it see column like text gives you Sort>Order>A to Z.

https://superuser.com/questions/342990/excel-sort-numeric-column-by-number

Thanks!

 

[pelozami]

if it STILL doesnt sort correctly, then you need to convert the cells. NOT by a format command, that wont work.
make another column to convert the bad column: = value(a2)
then it should sort.

Problem solved!
There was a problem with comma..
https://turbofuture.com/computers/Excel-number-format-problem

Anyway, thanks for your help!