Convert SSN in Number format to Text

  • Thread starter Thread starter tyrynn28
  • Start date Start date
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.
 
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")
 
Back
Top