| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
updating phone number formatting
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replacing data | Excel Discussion (Misc queries) | |||
| Phone Number formatting | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Formatting Phone Numbers in a Merged Cells... | Excel Discussion (Misc queries) | |||
| concatenating and formatting area code and phone number columns | Excel Worksheet Functions | |||
Threaded Mode
