Leading Zeroes & XML

**jlhart76** · 06-03-2009, 03:35 PM

We get a file in XML every month, which strips the leading zeroes from our 9-digit ID number. So we have to re-format to add back in the 0s. We've tried all the regular tricks (using Custom Format, formatting to text, etc.) but XML removes all the formatting from your file. Is there a trick to getting the XML file to keep the leading zeroes?

**starryknight64** · 06-03-2009, 05:26 PM

Not sure how to attack your question... could you be more specific as to how we can help you?

**contaminated** · 06-03-2009, 05:37 PM

I didn't understand what u whant, but try this one...

"0"&A1 (formatted as text)

**jlhart76** · 06-03-2009, 05:54 PM

Originally Posted by starryknight64

Not sure how to attack your question... could you be more specific as to how we can help you?

We have an id number that is 9 digits, with leading zeroes. (ex. if the number is 123456, then 3 zeroes are added to the beginning to make it 000123456). When you send an XML file, it strips all formatting, including reverting the number back to 123456. How do I get XML to keep the 9-digit number instead of removing the zeroes?