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
|