Heres my dilemma and challenge€¦

€¦ This is through Automation€¦

Im receiving an XML file that has excel formatting€¦

Its very easy to import, the problem comes in when I import large numbers
(17 €“ 20 characters long)€¦ They should be imported as text, but they are
importing as numbers, so they appear as scientific notation€¦ When I go to
create a file from the data, the numbers are being written in the scientific
notation and not as text€¦

I am unable to control the content of the XML file. I do know the number is
in a certain column€¦

Also, when I double click on a cell, I can edit it and place a single quote
and it will store the number correctly€¦ But, when I do it through automation,
it wont convert€¦

We are using excel 2003€¦ In the process of upgrading to 2007, but wont be
for another 6 months€¦

Fustrating...

Your help would be greatly appreciated..

Thanks,
Michael