Hi Gator,
You can multiple all the numbers by 1 in next column and then Paste Special
Values.

HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Gator" wrote:

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