Leading zeroes on socials

[austin3515]

I'm trying to format a social with leading zeroes. I want the field (when exported) to continue to be a number, so that it can be reimported, so witching it to a format function won't work. I tried putting "@@@-@@-@@@@" in the format property, which adds the dashes, but does not keeping the leading zero.

Any help appreciated!!

 

[Norie]

If the field is numeric try 000-000-000 for the format.

 

[austin3515]

THANKS!!
(I tried that before, but foolishly included quotes around the zeroes!!)