Rick,

Select the cells. Edit - Clear - Formats.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Rick Wetzel" wrote in message
...
I use a third party application that exports data and really wierd
(impossible to work with) formatting to Excel. I currently remove all
formatting by selecting all, copy and then paste into Notepad. Then I
delete
everything on the worksheet and do a select all copy from Notepad and a
Paste Special, Text Only back into the worksheet. This works great but is
cumbersome.

Please, is there an easier way? Thanks
--
Rick Wetzel