If the number is in cell A1, use the formula

=RIGHT(A1,4)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"ExcelB" wrote in message
...
how do i show only the last four digits of a credit card number