How do I view formulas by values not by which cells they use to c.
 

Eg. formula is =B1 + C1
where B1 is 3 and C1 is 4
how can I get the cell to say
=3 +4

thanks

Select B1 in the formula bar and press F9, do the same for C1
press enter

Otherwise you need to use VBA



--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"excelhelp" wrote in message
...
Eg. formula is =B1 + C1
where B1 is 3 and C1 is 4
how can I get the cell to say
=3 +4

thanks