Remove Formatting

Hi All,
I've received an .xls file from a customer that contains a generous
amount of formatting. I use a 3rd party program to link spreadsheets to
AutoCAD drawing files (.dwg) but it chokes on this particular
spreadsheet I assume due to all of the formatting. Is there a way to
remove all formatting from a spreadsheet and maintain all of the data?
Dave
DDP

Nick
Sun Feb 24 10:23:02 CST 2008

Dave

Open it and select all the data and then Edit>Clear>Formats

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk





"ddpcad" <nospam@diespammers.com> wrote in message
news:CHgwj.11$0C5.10@newsfe05.lga...
> Hi All,
> I've received an .xls file from a customer that contains a generous amount
> of formatting. I use a 3rd party program to link spreadsheets to AutoCAD
> drawing files (.dwg) but it chokes on this particular spreadsheet I assume
> due to all of the formatting. Is there a way to remove all formatting from
> a spreadsheet and maintain all of the data?
> Dave
> DDP

Don
Sun Feb 24 10:36:31 CST 2008

UN tested but try this
sub df()
Application.Cells.FormatConditions.Delete
end sub

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
"ddpcad" <nospam@diespammers.com> wrote in message
news:CHgwj.11$0C5.10@newsfe05.lga...
> Hi All,
> I've received an .xls file from a customer that contains a generous amount
> of formatting. I use a 3rd party program to link spreadsheets to AutoCAD
> drawing files (.dwg) but it chokes on this particular spreadsheet I assume
> due to all of the formatting. Is there a way to remove all formatting from
> a spreadsheet and maintain all of the data?
> Dave
> DDP

Dave
Sun Feb 24 14:21:02 CST 2008

Nick Hodge wrote:
> Dave
>
> Open it and select all the data and then Edit>Clear>Formats
>

thanks, that worked :)
Dave

Nick
Sun Feb 24 15:01:29 CST 2008

Dave

Great, glad it worked

--
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk





"Dave Jones" <nospam@diespammers.com> wrote in message
news:Okkwj.38$0C5.36@newsfe05.lga...
> Nick Hodge wrote:
>> Dave
>>
>> Open it and select all the data and then Edit>Clear>Formats
>>
>
> thanks, that worked :)
> Dave