ExcelBanter - View Single Post

"Don Guillett" wrote in message
...

"kyegibbon" wrote
in message ...

no i meant the actual content to be what is displayed.
if you click on the cell, and look in the = textbox in the top toolbar
it's still going to contain the formula, i want it to just contain the
result of the formula if you know what i mean?

I don't know what you mean
if you put in a formula =2*3, in the formula box that is what you will
see. In the cell you will see 6

If you want the formula to show 6, then Copy, and Paste Special/ Values
--
David Biddulph