If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Credit Card Number in excel
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 |
#2
|
|||
|
|||
Credit Card Number in excel
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 --------------- Jacob Skaria "Prem Soni" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|