How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Bryan Your Own Question

Bryan, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 1445
Experience:  Have been using MS Office since Office XP and know VBA coding very well
Type Your Microsoft Office Question Here...
Bryan is online now
A new question is answered every 9 seconds

How to prevent losing leading zeros and numbers being converted

This answer was rated:

How to prevent losing leading zeros and numbers being converted to scientific notation when importing an xml file into Excel 2007

JBryan42 :

Welcome to JustAnswer. My name is XXXXX XXXXX I will be assisting you today. Please do not rate this session until it has been completed.

JBryan42 :

You would need to tell Excel that the data being imported is a string value. The easiest way to do that would be to insert quotes before and after each number.




I will try and advise.

JBryan42 :

Ok. Let me know if you run into any troubles.


I may have more question on this later

Bryan and 3 other Microsoft Office Specialists are ready to help you
Customer: replied 3 years ago.


Help. Need a script that can be used to repeatedly convert a fixed length field file to a tab delimited file. Once you respond I will send 3 files. I plan to upload the 3 files below to wikisend for you to download and use to create the script that can run on my laptop and eventually a win 2008 server. The 3 files to be sent are: 1. an instance of the fixed length file that needs to be parsed 2. the file layout document showing the length of each feild 3. the result desired - a tab delimited text file. I need a process that can be used over and over to convert the same fixed lengthed file format to the desired tab delimited result. Thanks. Jerry