View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default 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