Yes, this works, however I have about 20 different price sheet that are
formatted in a specific way (colour, fonds, highlights). I am loosing all
my formatting this way.
ED

"Nick Hodge" wrote:

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