I have a spreadsheet in which I am accessing data from a page in the
spreadsheet. For example:
Cell C9 = +Tech_No where Tech_No is defined on another page in the
spreadsheet. For some reason, when I type in a change to the formula,
the formula appears rather than the value of the formula. For example,
I changed, one of the cells to be:

=if(value(tech_no) = 0,"",tech_no))

Rather than "" or tech_no, what appeared in the cell was the actual
formula. I believe I may have a setting that is not correct.

Can anyone help? Thanks.

Connie

This can happen if either the cell with the formula or the cell the formula
is referencing is formatted as Text.

Select the cell with the formula and the one next to it and do

Edit=Replace
Replace what: =
Replace with: =

this will usually cause the formula to begin to work. However, if you edit
it again, it will revert back. So you might want to change the formatting.

--
Regards,
Tom Ogilvy


"Connie" wrote in message
ups.com...
I have a spreadsheet in which I am accessing data from a page in the
spreadsheet. For example:
Cell C9 = +Tech_No where Tech_No is defined on another page in the
spreadsheet. For some reason, when I type in a change to the formula,
the formula appears rather than the value of the formula. For example,
I changed, one of the cells to be:

=if(value(tech_no) = 0,"",tech_no))

Rather than "" or tech_no, what appeared in the cell was the actual
formula. I believe I may have a setting that is not correct.

Can anyone help? Thanks.

Connie