It sounds like 1900.04 is numeric and 1900.04-05 is text.

You could make sure that you entered all the items as text by preformatting the
column as Text or by entering your data with a leading apostrophe: '1900-04

Or you could use a helper column:

=""&a2

If you concatenate your 1900.04 number with the empty string, the result will be
a string.

Then you can drag that formula down and sort by that column.

Tamesh wrote:

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.

--

Dave Peterson