| Home |
| Search |
| Today's Posts |
|
#12
|
|||
|
|||
I don't have another guess.
Sorry. Hilary wrote: Hi Dave. No, it's not part of a merged area nor has the cell been part of multiple cells that were formatted as you described. And finally, I entered ?activecell.numberformat and got "general." I'm stumped! Hilary "Dave Peterson" wrote: Is the cell part of a merged area? (maybe it's centered in those cells that are merged?) Has the cell been part of multiple cells that were formatted via: cells|format|alignment tab|horizontal text alignment box: Center across Selection I remember having trouble turning that off in earlier versions and keeping alignment the way I wanted. Are you sure that the cell is really formatted as general: select the cell hit alt-f11 (to get to the VBE) hit ctrl-g (to see the immediate window) type this: ?activecell.numberformat do you get: General returned? Hilary wrote: Hi. I have a user with an Excel worksheet. There are multiple rows and columns and they are all set on center alignment, (center alignment icon on the toolbar as well as Format Cells -- Horizontal Alignment -- Center.) The alphabetical characters align correctly but the numerical don't, as they will only left align. Format Cells -- Number is set to General, so I don't know why it won't change the alignment. Other than the worksheet being corrupted, I don't know what could be wrong with it. Any suggestions are much appreciated. Thanks! Hilary -- Dave Peterson -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| Cell Change Color - Need Help | New Users to Excel | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
