Simply changing the cell formatting isn't enough. If its just one cell,
click it, click in the formula bar and hit F2. For lots of cells, enter '1'
in a convenient empty cell, copy it, highlight the offending cells and paste
special, multiply, OK,
Regards,
Alan.
"Caseybay" wrote in message
...
I'm using the sum function to add 6 numbers in excel. In one particular
target cell, it refuses to print the answer; instead it prints the
formula. I
have made sure that each of the 6 numbers and the target cell are
formatted
"number", not "text".