< Can anyone help? Yes.

Just tell us what the data looks like, and what you want it to be.

Regards
Fred.

"Darrel" wrote in message
...
I have imported a database and cannot format the phone numbers I have tried
formatting the cells prior to importing and also tried conditional
formatting. For some reason these numbers always show up without a space
between the brackets. Can anyone help?