View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bill Ridgeway Bill Ridgeway is offline
external usenet poster
 
Posts: 268
Default All numbers won't sort

Some cells may be formatted differently and in a way which is not
immediately obvious. Sort the cells and have a look (edit) at the cells
either side of the 'point of error'. Those which are straight numbers are
'true' numbers. Those that have a ' in front of them are formatted as text.

Regards.

Bill Ridgeway
Computer Solutions

"Barb" wrote in message
...
I am sorting numbers in a column. All are formatted number. When paint
the
column to sort, there are some numbers that will sort and others don't so
anything.

They look like below:

79668
79672
79762
73025
73026
73027
73033
73042
73050
73057
75028
75029
75031
75053
75057
79637
79638
79639

Why won't they all sort?