C
Carlton A. Barlow
I would like to use the results of a formula in a cell as an actual number.
Any help would be appreciated?
Any help would be appreciated?
How do I change cell that contains a formula to an actual number
F
Frank Kabel
Hi
copy the cell and use 'Edit - Paste Special - Values'
--
Regards
Frank Kabel
Frankfurt, Germany
im Newsbeitrag
news
[email protected]...
copy the cell and use 'Edit - Paste Special - Values'
--
Regards
Frank Kabel
Frankfurt, Germany
im Newsbeitrag
news
[email protected]...
J
James R-S
An easy way to do this is when editing the formula just type cntl+"=". It
immediately changes the formula to text. Hit escape to bring back the formula
or hit enter to accept the value.
James R-S.
immediately changes the formula to text. Hit escape to bring back the formula
or hit enter to accept the value.
James R-S.