Thread: decimal sorting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tamesh
 
Posts: n/a
Default decimal sorting

Hi,

I have a spreadsheet with an inventory list. The inventory items all have
number associated with them (i.e. 1900.04). However Some of the inventory
has multiple items associate with the same originating number (i.e.
1900.04-15). Is there a way to sort it so that all the similar numbers stay
together (i.e. 1900.04, 1900.05, 1900.04-15) without sending the hyphenated
values to the bottom of the list after 2000 for example.

Thanks.