How to replace formula with its result

  • Thread starter Thread starter jclown
  • Start date Start date
J

jclown

Hello Everyone,

I am using a function to calculate stock levels. For example =2*BR5.
But what I want is the cell to display the answer once it has been
calculated, to give me an absolute answer. So if I change the number in BR5
to results do not change.
Thanks in advance.
John
 
EXCEL 2007

Ctrl-C

- then Home / Clipboard group / Paste / Paste Values

If my comments have helped please hit Yes.

Thanks.
 
Excellent Thanks.
John

trip_to_tokyo said:
EXCEL 2007

Ctrl-C

- then Home / Clipboard group / Paste / Paste Values

If my comments have helped please hit Yes.

Thanks.
Click to expand...
 
Back
Top