Missing Zeroes on Coupon File

Problem

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

 

Answer 

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

 

Example 
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