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

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

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