Number Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Hi Gator,
You can multiple all the numbers by 1 in next column and then Paste Special
Values.

HTH,
 
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
 
Back
Top