convert formula to values

[ehsas]

How can I be able to change the formula to it values only.

Regards,

 

[plettieri]

Do you mean one cell,...ie F2 then F9 keys...or a range to convert line copy | special paste | values

pll

 

[stevebausch]

My guess is they want to "freeze" dates. I guess other situations might prompt this inquiry, but for many newcomers, experience with formulas begins, and ends, with Today(), or Now().

 

[ehsas]

If i change the formula to value only can I reverse the formula back after saving.Regards,

 

[VoG]

Copy your data. Go to another sheet or somewhere else on your sheet. Edit/Paste Special and tick Values. You will now have the values only but your original formulas will be intact.

If I have misunderstood please post back.

 

[ehsas]

This is Ok but how I can reverse the formula after converting to the value or saved the file.Regards,

 

[plettieri]

I believe the reason for copying your "in tact" data to another spread sheet or coping it to another range (as VoG™ states) of your worksheet(before you convert) is that once converted to values and saved...its done ...I don't think you can get reconverted values back to formulars...it won't come "back from the grave"....

pll
This message was edited by plettieri on 2002-10-13 09:21