Sorting Numerical Data - Decimals

  • Thread starter Thread starter Michael B.
  • Start date Start date
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?
 
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.
 
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
 
I misread your post and my solution probably won't work.

Is this for Access or Excel?
 
Back
Top