Is there anyway that I can convert formulaes that is currently in cells to code? Thanks
H Hein Oct 21, 2008 #1 Is there anyway that I can convert formulaes that is currently in cells to code? Thanks
S Sheeloo Oct 21, 2008 #2 What do you mean by code? If you want to convert them to values then Copy and then Edit|Paste Special|Values If you want to convert them into the formula, simply replace = with '=. You can do that by Find/Replace option...
What do you mean by code? If you want to convert them to values then Copy and then Edit|Paste Special|Values If you want to convert them into the formula, simply replace = with '=. You can do that by Find/Replace option...
S Satyendra_Haldaur Oct 21, 2008 #3 If you want to see the formula instead of value in a cell u can use ctrl+ ` . ( ` is just above on tab)
If you want to see the formula instead of value in a cell u can use ctrl+ ` . ( ` is just above on tab)
S Stefi Oct 21, 2008 #4 You can also toggle displaying formulae or results via Tools>Options>Display>Formulae checkbox Regards, Stefi „Hein†ezt Ãrta:
You can also toggle displaying formulae or results via Tools>Options>Display>Formulae checkbox Regards, Stefi „Hein†ezt Ãrta:
