Credit Card Number in excel


Prem Soni


I am facing a problem in excel.
I have a database on website in that i have a column of credit card. when i
export that data in excel format all column are correct except credit card
one. it shows the credit card number (4050281000321114) in the format
After exporting in excel when i format this particular column in "TEXT" or
in other format it becomes 4050281000321110.

Kindly help me on this as its very urgent for me.


Jacob Skaria

If there is an option to Export to text or .csv, do so and open in Excel
using the Import Wizard..and in Step 3 mark the column data format for credit
card column as Text..and open

If this post helps click Yes

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question