I'm trying to use a map in Excel to import XML data but I get errors saying
'Some data was imported as text'.
These errors occur then I have numbers prefixed with zeros e.g. 0052, is
there any way of either getting all of the data imported as text format e.g.
"0052" or being able to choose how the field is imported or formatted?

Regards,

Huw Jenkins.