Thread: locking the result of a formula.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default locking the result of a formula.
Copy the cell; then use Edit | Paste Special with Values specified in the
dialog box
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Claire" wrote in message
...
Is there any way of copying and locking the result gained from a formula
so
the result doesnt change when cells used in the formula do??


Reply With QuoteReply With Quote