Convert SSN in Number format to Text

T

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.
 
M

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
Click to expand...

Format(ssn, "000000000")
 
Top