View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shivaraj Shivaraj is offline
external usenet poster
 
Posts: 4
Default 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