Thread: Number Format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gator gator is offline
external usenet poster
 
Posts: 66
Default Number Format

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