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?