CSV Files/Number Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I save an excel file as a comma delimited (CSV
file, BUT still maintain a format that allows for 15-digit
credit card numbers? These usually require a special cell
formatting (ie text or number) that gets lost when saved as
a CSV file

My understanding is that saving as CSV saves all formats
as "General." The result is a file that displays credit
card numbers in scientific notation (3.71528E+14)!! This
doesn't work for batch uploading to process credit cards

What can I do to have a CSV Excel file that actually
displays 15 digits!

Jere
 
They do not get lost but when you re-open it in excel it will truncate it
You either have to rename it to a txt extension or open it using
data>import external date>import data, use *.* as file format to see csv
files and the text import wizard will start, then you can select column data
format
as text and it will keep the text format (step 3).
If you change the extension to txt it will cause the wizard to start when
you open it
I assume you mean 16 digit credit card numbers.
 
Back
Top