last four digits of a social security number

G

Guest

Can anyone tell me how I can reduce a social security number to the last four
digits?
 
P

Paul B

elli, here is one way, with ssn in column A in B1 put =RIGHT(A1,4) and copy
down, paste valves back over your data if you need to.
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Z

Zack Barresse

To show it as a SSN, there is a Special format for that in the formatting
menu. It will show it as ..

123-45-6789

To only show four numbers, either enter only four numbers, or use a formula
....

=RIGHT(A1,4)

... where A1 is the cell which houses the SSN.

HTH
 

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

Old digital copier machines store what was copied on an internal hard drive! 8
How do I calculate age using a 12 digit social security number in MS Excel? 0
Hiding part of a Social Security Number 1
Calculating Social Security 3
How do I sum here using criteria there? 10
Show last four digits of SS# 3
Using CONCATENATE function to create email addresses from a list 2
How to display last for digits of SSN? 4

Top