Excel Changes Text Cells to Number Cells When Importing XML
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. |
All times are GMT +1. The time now is 05:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com