Format phone number formula

[wokkie]

Hi,

I want to create a conditional format to format telephone numbers.

Basically our phone numbers are made up of the code and the telNo. Normally the code doesn't have a 0, but sometimes it does, normally the telNo doesn't have the code but sometimes it does.

What I want is a formula to display the telephone number "correctly".

Please can someone point me in the right direction.

Thanks

Ian

 

[dgillz]

Picture({YourTextField},"(XXX) XXX-XXXX") is a good example of how to format the phone numbers. Combine this with a little if-then logic to get your desired output.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com

http://www.srhconsulting.com