Format Phone Number

  • Thread starter Thread starter Jessie
  • Start date Start date
J

Jessie

Hello.

I have a phone field formatted:

9995551212 that I have to change to:

(999)555-1212 on fixed width text output. Is there a way I
can do this using a query?

Thanks,
Jessie
 
Hello.

I have a phone field formatted:

9995551212 that I have to change to:

(999)555-1212 on fixed width text output. Is there a way I
can do this using a query?
Click to expand...

Use the Format() function: put in a calculated field by typing

ExpPhone: Format([phone], "(@@@)@@@-@@@@")

and export the resulting text string.

Note that setting the Format *property* of a field or form/report
control doesn't help with exports - the export software ignores it.
 
Back
Top