Missing Zeroes on Coupon File


The exported coupon file is missing zero's in front of a set of numbers.



The zero's are not "missing" from the file. Excel can hide the leading zero's, but with some steps, we can unhide them. 


My coupon file is not exporting the zeroes in front of my account numbers. 


How to Resolve

1. Open the Exported Coupon file in Excel 

2. Click the Data tab 

3. Select From Text/CSV

4. The Import Data window will open. Select the exported coupon file that is currently being worked on. Click Import

5. Under Data Type Detection click Do Not Detect Data Types

6. Click Load 


If the file had missing zeroes, it will now load with the missing characters. 

Did you find this article helpful?

0 out of 0 found this helpful