Number String to Phone Number 1

[yipster]

Hi,

I am trying to figure out how to convert a string of numbers to a phone number setting.

Right now the field just populate 1234567890 but I would like it to show (123) 456-7890. Is this even possible?

Thanks

 

[dgillz]

Use a formula:

Picture("(xxx) xxx-xxxx")

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[yipster]

Hi

I have the field selected but how do I add that function in?

 

[lbass]

You should replace your field with a formula that you create in the field explorer->formula->new area:

picture({table.phoneno},"(xxx) xxx-xxxx")

This was what Don meant to say, I'm sure.

-LB

 

[dgillz]

Yes, thanks LB.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[yipster]

Thanks I got it.