Formatting Formula Results to Text

[Reggie]

Hello,

I have a sheet full of formula-derived cells, that I
would like to format to the results. For example:

Cell A1 may contain the formula =a2-b2, and the answer
would be 17. How can I get the cell to forget the formula
and just have the 17 appear in the cell text box when
clicked upon?

No, I'm not falsifying any records!

Reg

 

[Frank Kabel]

Hi
- copy the cell
- goto 'Edit Paste Special' and choose 'Values'

 

[Reggie]

Sir,

You're a genius! Thank you very much! Guten Tag!