end number keeps changing to '0'
Hello,
I am trying to keep trackof credit card numbers, i put in a custom formating
that looks like this: ####-####-####-#### so i can just type the numbers in
without having to type '-'.
The only problem is that is always turns the last number into a '0' zero.
for instance if the number is:
4519-3589-2000-1875
the formula changes the number to this:
4519-3589-2000-1870
Thank you,
shivaraj
|