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

[Guest]

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

thanks

 

[Peo Sjoblom]

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)