Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers Left-Justifying
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers Left-Justifying
Since it's only affecting one workbook, I'd try looking he
Format|Styles|Select Normal|Modify|Alignment tab See if Horizontal alignment is set to General. 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! -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers Left-Justifying
One more thing to check...
If you type a formula in any cell, do you see the formula in the cell--or do you see the results of that formula? If you see the formula, try: tools|Options|view tab|uncheck formulas. 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! -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers Left-Justifying
Thanks, un-checking Formulas did it. I didn't have any formulas on this
Worksheet so I it didn't occur to me that Formulas would be a problem. "Dave Peterson" wrote: One more thing to check... If you type a formula in any cell, do you see the formula in the cell--or do you see the results of that formula? If you see the formula, try: tools|Options|view tab|uncheck formulas. 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! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Numbers left-aligned in a cell | New Users to Excel | |||
excel column & row numbers displaying right to left? | Excel Discussion (Misc queries) | |||
Justifying text | Excel Discussion (Misc queries) | |||
how to add numbers to the left or right of the existing numbers? | Excel Discussion (Misc queries) | |||
Why does the decimal move to the left on all numbers? | Excel Discussion (Misc queries) |