J
Jerel
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 special cell
formatting (ie text or number) that get 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!?
Jerel
file, BUT still maintain a format that allows for 15-digit
credit card numbers? These usually require special cell
formatting (ie text or number) that get 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!?
Jerel