View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bondi Bondi is offline
external usenet poster
 
Posts: 94
Default 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