Hi everyone,
I need help, again. I have several worksheet that I need to combine the
information in order to upload into a access database. I problem that
I'm having is the phone numbers are formatted differently therefore
they are not all of the are uploading. The Access data base field is
classified as text. The phone numbers that did upload correct are
formatted as special / phone numbers. I tried changing the cells
formatting but it doesn't update the existing information. It does
update if I type the number in by hand.

Is there away of updating the existing numbers to be formatted like the
example below.
(555) 777-4444.

All suggestions are always appreciated.
Thanks
Lostinformulas


--
lostinformulas
------------------------------------------------------------------------
lostinformulas's Profile: http://www.excelforum.com/member.php...o&userid=35229
View this thread: http://www.excelforum.com/showthread...hreadid=569094