Ed

Highlight the data and then copy it, now immediately right click and select
paste special+Values, or Values and number formats

This will kill the formulas for you

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/
"ED" wrote in message
...
I want to take all my formulas out the the worksheet and just display the
values