Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
How do i change numbers in text format to number format? | New Users to Excel | |||
excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) |