Hello.
Thank you in advance for any help/guidance you all can provide.
My issue is as follows:
I have standardized report I use on a daily basis, this report contains social security numbers(SSN) without the leading zeros. I need to add the leading zeros to be able to use the correct SSN for other reporting needs.
I have tried to use the Special Number formatting for SSNs, the issue I have with this is that it only changes the appearance of the number, the actual number data does not change.
Is there a function, or set of functions I can use to easily add the leading zeros to a column?
Example below:
<TBODY>
</TBODY>
Thank you in advance for any help/guidance you all can provide.
My issue is as follows:
I have standardized report I use on a daily basis, this report contains social security numbers(SSN) without the leading zeros. I need to add the leading zeros to be able to use the correct SSN for other reporting needs.
I have tried to use the Special Number formatting for SSNs, the issue I have with this is that it only changes the appearance of the number, the actual number data does not change.
Is there a function, or set of functions I can use to easily add the leading zeros to a column?
Example below:
Current Report Style | Needed Report Style |
35 | 0035 |
60522402 | 060522402 |
<TBODY>
</TBODY>