yeah, that would be a bit quicker <vbg

Bob


"Tom Ogilvy" wrote in message
...
or rather than edit each cell, after formatting as general (or other than
Text), select the cells and do Edit=Replace

Replace What =
Replace With =

so in each box put in an equal sign. Then click replace all and the
formulas should display the values.

--
Regards,
Tom Ogilvy

"Bob Phillips" wrote in message
...
Allan,

Unfortunately, if it was text, changing the column back to general does
solve it. You need to edit each cell with the formula to revert it.

--
HTH

-------

Bob Phillips
"Allan Blount" wrote in message
...
Now you come to mention it i think the column maybe formatted as text,
but i did try and change it and nothing happened.

I wasnt to sure what to format the column as to show the values of the
formuala as i have never come across this before?

BTW, thanks for your swift reply.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!