Number Format

[Guest]

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?

 

[Guest]

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

HTH,

 

[Jim Rech]

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
|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