Numbers showing Up Centered in Cell ?


B

Bob

Hello,

Using Excel 2007.

Have a column formatted as Numbers.
When I put a number anywhere in the column, it shows up to the right of
the cell.
Fine.

If I now, at the end of the column, do a SUM( ), the result is correct,
but it shows up in the centered position,
not on the right. The SUM cell is also (definitely) formatted as a number.

Why should this be ?
Shouldn't the SUM also show up on the right ?

Thanks,
Bob
 
Ad

Advertisements

C

Claus Busch

Hi Bob,

Am Thu, 15 Jan 2015 08:47:45 -0500 schrieb Bob:
If I now, at the end of the column, do a SUM( ), the result is correct,
but it shows up in the centered position,
not on the right. The SUM cell is also (definitely) formatted as a number.

right click to SUM cell => Format Cells => Alignment => Horizontal
Alignment = "General"
If then the position is left click to the column header => TextToColumns
=> Finish


Regards
Claus B.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top