Format phone not working

  • Thread starter Thread starter Jennifer
  • Start date Start date
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!!
 
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.
 
Back
Top