social security numbers in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an excel spreadsheet that currently displays social security numbers
in this format. 000-00-0000. Is there a way to change that format so only
the last five digits display? example ***-*0-0000

Thank you.
 
Not and keep them from prying eyes.

You could use a helper column and just show those last 5 digits, then protect
the worksheet. But worksheet protection is very easily broken--so you wouldn't
want to share this file with anyone who shouldn't see the complete SSN.
 
But if you do, don't share with people who shouldn't see them.

And make sure anyone you do share them with understands that, too.)
 

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

Unformating social security numbers 4
Can't figure this out 1
Preformatting Excel Prior to Opening Spreadsheet 1
remove dashs from social security numbers 4
How do I add a 0 and 2 dashes to a truncated soc. sec.# in a cell 10
Working with social security numbers 4
Converting Phone Numbers 4
Only extract numbers from a string of text 4

Back
Top