Converting Files With 16 Digit Numbers

M

monicamarie

Board Regular
Joined
Sep 2, 2008
Messages
72
Office Version
  1. 365
I have to export data from an apllication into a CSV file. One of the fields of data contains 16 digit card numbers. Unfortunately, the application does not give me any options as to how I want the data converted such as text, general, etc. When the export is completed, the end result is that the column with the 16 digit card numbers are all in scientific format and all end in a zero. Is there anyway to fix this after the fact? Or is the last digit lost once the export is done?

I would like to find a way to change the numbers back to text (or any other format that allows the cells to display all 16 digits as well as keep the last original digit).

Is this possible? Thank you for any help you can give me.
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
Sort by date Sort by votes
Could you concatenate it with a text character so it keeps the format?
Obviously you'd have to remove the character when you wanted to access it as a number.
Maybe you could use a space character?
 
Upvote 0
I tried to concatinate with a text character which allows the whole number to be displayed but the last digit is still a zero. I wonder if the last digit is lost at conversion.

Thank you for the suggestion.
 
Upvote 0
How about concatenating a character at beginning AND end?

How about using LEFT and RIGHT to split the 16 digit number into 2 x 8-digit characters if it keeps it up to 8-digits?
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question
Number format with 6 digits from import without leading zeros
Replies
4
Views
489
bkeebaugh
B
PETRODATAjames
  • Question
Random 6-digit or 9-digit numbers that do not repeat and do not start with 0 (zero)
Replies
2
Views
553
Legacy 143009
L
J
  • Question
Convert job numbers to text for wildcard search
Replies
1
Views
241
Farscape2020
F
J
  • Solved
Need help in finishing a macro..
Replies
4
Views
321
jocote46
J
H
  • Solved
Column Formatting issue - VBA importing multiple CSV files into one Excel sheet.
Replies
2
Views
362
heathball
H

Forum statistics

Threads
1,214,426
Messages
6,119,414
Members
448,895
Latest member
omarahmed1

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top