Exporting phone number input masks to text

[WSM]

Table has fields for both phone numbers and fax numbers.
They both use the Phone Number input mask.

When exporting to text, it is exported as a string of ten digits.
nnnnnnnnnn

Is there an expression to create a caluculated field, or some other
method, to get it to look like a phone number in the text file
(nnn) nnn-nnnn

Thank You
Bill

 

[John Nurick]

Hi Bill,

Use the Format() function in a calculated field. The format string will
be something like "(000) 000-0000".

 

[Dancing Bear]

Thank you so much Mr. Nurick - it did exactly what I wanted.