how convert cell formula value to text

Pecoflyer · Jul 11, 2009

add a ' before the formula

--
Pecoflyer

Cheers -

'Firefox 3.5' (http://www.mozilla.com/en-US/firefox/all-beta.html)
really IS fast !

Gord Dibben · Jul 11, 2009

Copy>Paste Special>Values>OK>Esc?

Gord Dibben MS Excel MVP