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