Unable to Sum() Number Values

[Always Learning]

Hi Everyone,

Can you help me please.
I have a column of numbers. I have formated the cells as number but when I
try to sum() the column it does not calculate, it just leaves the words
Sum() in the cell. Also any cells with zero in them display as 0 and not
0.00 it's as if the contents of the cells are still text but I have
formatted to number.

Does anyone know what's going on and how I get over this.

Thanks for your help it's appreciated.

Best Regards,

Steve Wilson.

 

[Nick Hodge]

Steve

'Numbers' often get stuck as text in Excel. Enter a 1 in a blank cell and
copy it. Highlight the text numbers and then Edit>Paste
special...>Values+Multiply. This will 'shift' them into being seen by Excel
as real numbers

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Bob Phillips]

To prove Nick's suggestion, try this. Enter

=SUMPRODUCT(--(A1:A10))

and see if you get the correct results (adjust the range to suit)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Arvi Laanemets]

Hi

Do you see "Sum(...)" or "=Sum(...)" in cell?

When 1st is the case, then you left '=' out from formula. Otherwise check
format of cell with formula - it must'nt be text.

 

[Jerry W. Lewis]

Also check Tools|Options|View and make sure that Formulas is not checked.

Jerry

 

[Always Learning]

Hi Guys,

Thanks for your help and time.
Nicks tip solved it for me.

Best Regards,

Steve Wilson.