Applies to Version 4.5 and below
This is really an Excel issue and not a Znode Storefront issue. The problem is that Excel sees Credit Card numbers as very large numbers and not strings. Since this number is too large for Excel to handle it tries to display it in scientific notation (for example 1.234E5 is equivilent to 123,400).
Here is the solution:
- Go to the Admin and click on Orders in the left nav.
- Click on the "Download Orders to Excel" button.
- When prompted choose to save the file to your local hard drive.
- Open Excel and select "Import" and specify ".csv" files. For Excel XP look under the Tools menu. For Excel 2007 look on the Data tab and From other sources.
- When you are importing select "delimited" and choose the "comma" as the field separator.
- In the next step of the wizard you will be able to select the type of each column. This is where we will be addressing the formatting issue. Use the horizontal scroll bar to find the Credit Card Number column. Click on that column and select "text" as the format.
- Continue the wizard until it is complete. You should now be able to read the credit card numbers.
