I'm not sure that putting VALUE around a sum function will bump 'text
numbers' into actual numbers

Try entering a 1 in a spare cell and copy it.

Highlight B24:E24 and then EditPaste Special...Values+Multiply. This
should fix the numbers

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Mr_Philby_Takeshi" wrote in
message ...
hello,

I have created a summary sheet for my personal budget summarising totals
for
the financial year. I am trying to add a row of cells B24 to E24 which
have
the values $11.60, $0.40, $15.00 and $15.50 using the SUM function. I know
it
equals $42.50 because it displays this total in the status bar when cells
B24:E24 are highlighted. However, the function returns a result of $0.00
in
cell F24. The cells are formatted as currency. I have tried embedding
VALUE()
into the sum function as suggested by another user on this discussion
board
with no success. Any ideas of possible solutions?

cheers Phil.