An easy way to convert numbers that have been entered as text to true
numbers is:

-Copy an empty cell.
-Select the range of text/numbers.
-Do an Edit, Paste Special, selecting Values and Add.
-Press Esc.
--
Jim
"Gator" wrote in message
...
|I have highlighted a field with integers and formated as General. For some
| reason some of the numbers are on the left side if the cell and others are
on
| the right side. When I try to sort, it sorts the ones on the left side
then
| the right side, it's like two different groups. When I double click the
cell
| with a number on the left side and hit enter, the number moves to the
right
| side. How can I format the field where all the left sides are on the
right
| and the entire field will sort instead of it treating it as two seperate
| groups?
| --
| Gator