Convert SSN in Number format to Text

[tyrynn28]

Hello. I know there is a way but I can't find it. I am trying to
convert a SSN field from a number to a text format. How do I go about
this?

For example:
Current format: 12345678
Needed format: 012345678

Any help is appreciated. Thank you.

 

[Marshall Barton]

Hello. I know there is a way but I can't find it. I am trying to
convert a SSN field from a number to a text format. How do I go about
this?

For example:
Current format: 12345678
Needed format: 012345678

Format(ssn, "000000000")

 

[tyrynn28]

Format(ssn, "000000000")

Thank you!