16-digit ID (credit card) number formatting

[kreestar]

Hi there,

When opening a CSV file in Excel that contains a number > 15 digits, the final digit is zeroed (or rounded up).

I've been doing some online searches, which have told me *why* it does this and that I should be formatting my data to text (which, if I do it after the fact in Excel, the final digits are already 0). Most of the solutions given work for people *entering* data, not opening existing files that may not be text-formatted.

I've tried formatting an entire workbook as text and then opening the CSV (opens in a new spreadsheet).
Also tried opening the CSV as text and pasting into a text-formatted Excel sheet, which keeps the full numbers, but the moment I Text-To-Columns it, it does its usual 15+ thing.

Help!

Kreestar

 

[pgc01]

Hi Kreestar

Rename the extension of the file from ".csv" to ".txt". What will happen is that when you open it in excel you will be taken to the Text Import Wizzard, where you can specify that the column with the CC number is to be imported as text.

 

[Andrew Poulsom]

Change the file extension from csv to txt. Then when you open it you will get the Text Import Wizard and you can specify the Text format for that column at Step 3.

 

[kreestar]

Re: 16-digit ID (credit card) number formatting - SOLVED

And so it did ... so easy.

Solved, thanks as always!