Thanks very much--both of your suggestions make it work perfect--appreciate
the help!

"George Nicholson" wrote:

Sounds like you have some client 'numbers' that are actually being stored as
Text. Using formatting to "convert" them is often a waste of time. What I
usually do is:
- Format an empty cell with the same format you want applied to your text
numbers
- Place the number 1 in that cell (important to apply number formatting
to cell first, to make sure it isn't text)
- Copy
- Select the text numbers you want to convert
- EditPasteSpecial. Select both "Values & Number Formats" and Multiply.
OK

HTH,


"SJC" wrote in message
...
I have a spreadsheet which displays data in rows for about 350 different
clients. Each client has an assigned number which leads each row. When I
sort the rows so that they will appear in numerical order, the majority of
the rows are sorted correctly, but about 30 rows are brought to the top of
the spreadsheet out of order. Besides cutting and pasting them where they
belong, are there any other options for fixing this sorting problem?