Sorting Numerical Data - Decimals

M

Michael B.

Excel sorts decimals in the following order:

..1
..163
..2
..3
..312
..4

Is there any way to treat the decimals as whole numbers in the sort, so that
the order would come out .1, .2, .3, .4, .163, .312?
 
J

Jerry Whittle

Wrap the CStr() function around the field name. Put that in the Order By
clause of a SQL statement or put it in the field of a query and sort on it.
 
J

Jeff Boyce

Michael

I'm not following the logic of the sort order you proposed.

Are you saying you want to treat the decimal values as if they were
integers, then sort numerically?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

Jerry Whittle

I misread your post and my solution probably won't work.

Is this for Access or Excel?
 
Top