Number format for cells
bgscoop wrote:
I need to enter full credit card numbers into an excel sheet that is
created to keep track of transactions. I need to see only the last 4
digits, though.
Tried many things so i hope you guys can help me figure this one out.
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
|