Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
social security numbers in Excel
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
social security numbers in Excel
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. MelissaC wrote: 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. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
social security numbers in Excel
Don't keep SS #s in Excel.
"MelissaC" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
social security numbers in Excel
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.) Dave F wrote: Don't keep SS #s in Excel. "MelissaC" wrote: 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. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FedEx tracking numbers in Excel | Excel Discussion (Misc queries) | |||
Converting numbers stored as dates to text in Excel | Excel Discussion (Misc queries) | |||
How do I sort Library of Congress call numbers in Excel? | Excel Worksheet Functions | |||
excel viewer | Setting up and Configuration of Excel | |||
How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) |