Numbers showing Up Centered in Cell ?
 

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

---
This email has been checked for viruses by Avast antivirus software.
http://www.avast.com

Numbers showing Up Centered in Cell ?
 

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.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional