Frncis
Member
I have been tasked by my employer to convert all Social Security entries to the last 4 only. At present there is a small number, but as time goes on it will be very time consuming to do this manually. I have used the custom formatting to convert the first 4 of the Social Security to X. I.e. XX-XX-1234. Unfortunately the first 5 numbers are still visible if you click on the cell.
I am trying to have the system convert all entries to only the last 4, and if the cell is clicked on all the user sees is Xs and the last 4, or just the last 4. I am also trying to not require the user to delete first 5 numbers.
Is this possible?
I am trying to have the system convert all entries to only the last 4, and if the cell is clicked on all the user sees is Xs and the last 4, or just the last 4. I am also trying to not require the user to delete first 5 numbers.
Is this possible?