Leading zeros and exporting to excel

This is the knowledgebase for Profound UI, all resolved support and product questions are located here. Please search this forum before posting any new support and technical questions.
Locked
Profound Logic
Site Admin
Posts: 252
Joined: Fri Dec 14, 2007 1:09 pm
Contact:

Leading zeros and exporting to excel

Post by Profound Logic »

Question:
If I have an alphanumeric field (part number) that may contain leading zeros and use the export to excel function, what happens to the leading zeros? Do they get dropped?

Answer:
The file is exported into CSV format. The leading zeros will be there in the CSV file if it's an alpha field; however; excel may still sometime interpret the data as a number.
Locked

Who is online

Users browsing this forum: Google [Bot] and 0 guests