Format phone not working

J

Jennifer

I am using the following expression:

Cell: Format([Cell_Num],"(@@@) @@@-@@@@")

Most numbers are coming out okay but I have some that look like this:

((99) 9) -366-2599

I have tried typing the numbers in over and over but keep getting this
result on some. Please help!!
 
D

Daryl S

Check the phone number - does this text field have the parentheses in them?
(e.g. is the phone number stored in the database as "(999) 366-2599"? If so,
change it to 9993662599. The @ symbol will pick up the "(" character from
the data and use it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Table of content - format does not get saved 2
Paragraph numbering in Word 1
Inconsistent formatting of section numbers 0
Word 2016 - Difficulties Learning Style Creation/Application 0
Export Query Phone Format 1
ASK Field Formatting 1
You don't currently have permission to access this folder 0
Finding the proper style field and the numbered paragraph value within the style 0

Top