Phone Number Formatting

[petsgalore]

Hi,
I have a similar question to BENTK in thread767-1020693 except that my phone number data is a 10 digit number (example: 9999999999) not a string.

When I tried Picture(({field.name}),"xxx-xxx-xxxx") to format the data, it gave me the error 'A string is required here'. When I tried Picture(totext({field.name}),"xxx-xxx-xxxx"), there were no errors but the data ended up looking like this: '9,9-99,-999,999.99'. I know it's probably something really simple that I'm just overlooking. Any ideas? Maybe another formula that would work for numerical data or something on one of the Crystal Reports menus that I missed?

P.S. - I'm working with version 8.5.

 

[synapsevampire]

Try:

Picture(totext({field.name},0,""),"xxx-xxx-xxxx")

-k