Forum Discussion
Could someone please screenshot the resolution; like I said I am new to this.
Hey Becky,
Your solution may be a little different than mine, but I ended up using the formula below. I will be instructing the users of my app to exclude the hyphens from the social security numbers.
If(Length([SS#]) = 9,
var text SSN = ToText([SS#]);
var text filler = "###-##-#";
List ("", $filler, Right($SSN,3)),
"Not Formatted")
Your solution may be a little different than mine, but I ended up using the formula below. I will be instructing the users of my app to exclude the hyphens from the social security numbers.
If(Length([SS#]) = 9,
var text SSN = ToText([SS#]);
var text filler = "###-##-#";
List ("", $filler, Right($SSN,3)),
"Not Formatted")