How can I format an SSN to display only the last four digits?

G

Guest

I'm using Excel 2002, and I'm trying to figure out how I can format a cell to
only display the last four digits of an entered number. I thought I'd done it
before, but I have no idea how. Help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trim all but the last four digits off a list of SSN's. 2
How do I enter a SSN but only display the last four digits? 1
How can I sort a list of numbers by the last 4 digits? 2
replace last four of ssn with xxxx 5
Custom Format on 16 Digit Number 5
Can't figure this out 1
how do i show only the last four digits of a credit card number 5
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1

Top