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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging Rows and Columns 1
Convert SSN to Number 7
Formatting the SSN 9
SSN Algorithm Encryption 2
Format of SSN Field on Form 2
Convert Text field to Number Field 3
converting ssn's 12
internal format for SSNs 1

Back
Top