Importing xml into Excel without the schema

[yorkshirelad]

I need to import an xml document into Excel 2007 but the standard import xml data link is forcing me to accept a colour scheme (schema).

I need to do a lot of work with the data is there an easy way of stripping the formatting out so the data sits in plain cells. Formatting it using the standard method doesn't remove the colours unless I'm missing something

Any help would be really appreciated

 

[yorkshirelad]

Got it the clear formatting works Alt+E+A+F