View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gizmo63 Gizmo63 is offline
external usenet poster
 
Posts: 43
Default Numbers Left-Justifying

Check that there isn't a rogue space at the end of the number or a ' at the
beginning, both will change it to text format.
If they've been copied from another data source you may get either. Simplest
way to confirm is to re-key the number and see if it shows as number should.

HTH

Giz

"tc69" wrote:

I just noticed that the numbers in one of my Worksheets are left-justifying.
They're just in General Format. Both existing numbers and new numbers I
enter into the Worksheet are left-justifying. My other Worksheets are fine.
Any ideas? Thanks!