cell will not center

H

Hilary

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
 
D

Dodo

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.
Click to expand...

Do you see (in the formula bar) an apostrophe ' before these numbers?
 
D

Dodo

Nope. No apostrophe.
Click to expand...

The only other thing I can think of giving this result, is when the
"numbers" are followed by spaces. This you can check too in the formula
bar.
 
B

Bryan Hessey

Is the user using Excel for the worksheet, or a viewer of some form?

Can the user, in another cell, put =A1+1 (where A1 is replaced with
address of one of the offending cells)

Does the offending cell show the data to the left and double width, as
it would be if Alt/Enter were used in the cell?

Are there any other clues, such as what happens if you re-enter the
number in the cell? (you can Ctrl/Z to un-enter that)
 
B

BizMark

Dodo said:
=?Utf-8?B?SGlsYXJ5?= [email protected] wrote in
-
Nope. No apostrophe.
-

The only other thing I can think of giving this result, is when the
"numbers" are followed by spaces. This you can check too in th
formula
bar.
Click to expand...


Did you previously set those cells to "Comma Style"?
If you look next to the icon for "Currency Style", you've go
"Percentage", "Comma" and "Add/Remove Decimal Place".

Once you've set a cell to Currency or Comma Style, even removing th
decimal places leaves that style set, and sets an invisible 'decima
tab' point.

Try going to Format -- Cells -- Number
Then, select Category as 'Number' and set the required number o
decimal places. This may fix it.

Regards,
BizMar
 
D

Dave Peterson

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?
 
H

Hilary

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
 
H

Hilary

Hi Bryan.

The user is using Excel for the worksheet. When I put =A1+1 (replacing with
the offending cell), it does not add the two numbers. Finally, nothing
different happens when I re-enter a number in the offending cell.

However, cells with alphabetical text do center properly.

Any other thoughts?

Hilary
 
H

Hilary

Hi Bryan.

The user is using Excel for the worksheet. When I put =A1+1 (replacing with
the offending cell), it does not add the two numbers. Finally, nothing
different happens when I re-enter a number in the offending cell.

However, cells with alphabetical text do center properly.

Any other thoughts?

Hilary
 
H

Hilary

Nope, no spaces either.

Dodo said:
The only other thing I can think of giving this result, is when the
"numbers" are followed by spaces. This you can check too in the formula
bar.
Click to expand...
 
D

Dave Peterson

I don't have another guess.

Sorry.
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
Click to expand...
 
D

Dodo

Hi Bryan.

The user is using Excel for the worksheet. When I put =A1+1 (replacing
with the offending cell), it does not add the two numbers.
Click to expand...

Doesn't that indicate that the offending cell's format is not number?!

What do you get as a result of this formula?

Does this all happen only on the user's puter or also on other machines
when you copy the spreadsheet there?
 
H

Hilary

Thanks for your help. We've decided to just call it a currupted file and copy
and paste into a new worksheet. Thanks though!

Hilary
 
Top