I am trying to create a spreadsheet that contains personal sensitive information, in this case, Social Security Numbers. Individuals will be asked to enter information, including their SSN. However, I want the SSN to be automatically encrypted once the user fills in the number. The number would show as “****-**-****” instead of the actual number. Much like when you supply passwords when logging into website and such. What options do I have and how do I apply to the workbook?
Example of table layout:
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Example of table layout:
Name | Position | Region | SSN | |
1 | Jack | Salesman | West | ***-**-**** |
2 | Jill | Salesman | North | ***-**-**** |
3 | Tom | Salesman | South | ***-**-**** |
4 | Jerry | Salesman | East | ***-**-**** |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>