veriable to constant

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

How its possible to change veriable values to constant values,
e.g. if I count "Excess" and the formula returns 10 and after deleting
"Excess" from the row then formula returns 0, I want that 10 become constant.

Thanks & Regards

Hassan
 
How its possible to change veriable values to constant values,
e.g. if I count "Excess" and the formula returns 10 and after deleting
"Excess" from the row then formula returns 0, I want that 10 become
constant.
Click to expand...

Select the cell, then click Edit/Copy (or key in Ctrl+C), leave the same
cell selected and click Edit/Paste Special, select Values from the Paste
area (leave None for the operation) and click OK. Finally, key in Esc to
remove the selection.

Rick
 
Back
Top