Can anyone tell me how I can reduce a social security number to the last four
digits?
Can anyone tell me how I can reduce a social security number to the last four
digits?
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
"elli" <[email protected]> wrote in message
news:[email protected]...
> Can anyone tell me how I can reduce a social security number to the last
> four
> digits?
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
--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.
"elli" <[email protected]> wrote in message
news:[email protected]...
> Can anyone tell me how I can reduce a social security number to the last
> four
> digits?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks