Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
showing 2 numbers in a cell | Excel Discussion (Misc queries) | |||
Excel cell showing Yr/Mo/Day in numbers only (09/11/06) can it b. | Excel Worksheet Functions | |||
checkbox centered in cell | Excel Programming | |||
Adding numbers in one cell and showing total in seperate cell | Excel Discussion (Misc queries) | |||
Cell alignment centered | Excel Programming |