| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enter a SSN but only display the last four digits?
I'm creating some spreadsheets for a government agency and need to capture
social security numbers. Is there some method for capturing the data but only show the last four digits. I currently use two columns: one for the full SSN with a narrow column width so only "##" appears; the second column uses the RIGHT function to list the last four characters. Does anyone know of any other techniques? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enter data and display function result in same cell | Excel Discussion (Misc queries) | |||
| how do I enter a value, display that many fields? | Excel Discussion (Misc queries) | |||
| Is there a (non-binary) "if x then enter y" forumula? | Excel Worksheet Functions | |||
| How do I display leading zeros so I can export a fixed in Excel? | Excel Discussion (Misc queries) | |||
| Conditional display of a .jpeg file? | Excel Discussion (Misc queries) | |||
Threaded Mode
