Hi,

Maybe you can enter the full creditcard number in a cell formated as
Text. Then take out the last 4 digites with something like:

=--RIGHT(A1,4)

Regards,
Bondi


i tried entering only right(a1,4) at first to see how it worked
in the cell it displayed ' #name? ' (without the apostrophies)
any idea how to get through this ?