Excel hard code those #'s without deleting the formula or typing#

J

JudiS

Hi,
I received this question from a Excel user:

'I have a worksheet that has cells with data looking at other worksheets. I
want to basically hard code those #'s without actually deleting the formula
and typing the number in.

How do I do that?'

Thanks for any information that you may have!
 
B

Bob Phillips

Copy>Edit>PasteSpecial>Values.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top