If u said this only for typing credit card purpose, not to cummulated I
suggest you change your format cells into "TEXT".
Good Luck..
"Jaxz24" wrote:
I am trying to enter a 16 digit credit card number into an excel spreadsheet.
For some reason however excel is truncating the last numerial and replacing
it with a '0'. It displays 15 digit numbers fine. Why is this and how do i
fix it? (ive tried cell formatting but to no avail)
|