Eg. formula is =B1 + C1 where B1 is 3 and C1 is 4 how can I get the cell to say =3 +4 thanks
E excelhelp Dec 6, 2004 #1 Eg. formula is =B1 + C1 where B1 is 3 and C1 is 4 how can I get the cell to say =3 +4 thanks
P Peo Sjoblom Dec 6, 2004 #2 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)
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)
