View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Prem Soni Prem Soni is offline
external usenet poster
 
Posts: 16
Default 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