Credit Card Number in excel

P

Prem Soni

Hi,

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
4.05028E+15.
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.

Thanks,
PREM SONI
 
J

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

Similar Threads

Formatting for credit card number input 5
download credit card statements to Excel 2
Typing a credit card number in a cell 3
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
Excel does not accept text format! 0
excel changes the last number I type in column??? 5
rounding problem need accuracy when using V Lookup 2
How do I calculate credit card interest with a formula? 2

Top