| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Typing a credit card number in a cell | Excel Discussion (Misc queries) | |||
| how do i show only the last four digits of a credit card number | Excel Discussion (Misc queries) | |||
| Credit Card Number | Excel Worksheet Functions | |||
| Credit Card Number | Excel Worksheet Functions | |||
| Custom format for credit card number | Excel Discussion (Misc queries) | |||
Linear Mode
