I have over a thousand xml files that I need to import into Excel. One of the
attributes in each xml file is a number that varies in length but generally
exceeds Excel's 15 significant digit limitation. I format that column as
text, but when I import the xml files, all the values in that column become
numbers with the trailing zeroes. I do not have to do any calculations on the
values. Storing them as text works fine. Does anybody know how I can preserve
that column as text and store the original value as it's being imported? I
don't usually have Internet access at work, but I will respond to any
responses as soon as I can.