if i was to enter a credit card number in excel it auto formats it to
this
1.23412E+15
for this number 1234123412341234

and when i enter it in and format it as a number it makes the last
number a 0 ?
1234123412341230

why?

how to fix?


--
mark petrak
------------------------------------------------------------------------
mark petrak's Profile: http://www.excelforum.com/member.php...o&userid=26804
View this thread: http://www.excelforum.com/showthread...hreadid=473146