| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell content differes from formula bar
I posted this earlier but I've lost the thread  I imported a database from !ACT into Excel which includes a phone number column. Some phone numbers are like this: (603)123-4567 and others are like 603-123-4567.They sort seperately so I'd like to edit the numbers to eliminate the parenthesis. The problem is that when I select the cell the parenthesis disappear and they aren't there in the formula bar so I can't edit to fix Reformatting the whole column as a phone number has no effect. -- philtyler ------------------------------------------------------------------------ philtyler's Profile: http://www.excelforum.com/member.php...o&userid=12476 View this thread: http://www.excelforum.com/showthread...hreadid=539869 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Incorporating cell content into a message in a formula | Excel Worksheet Functions | |||
| Cell addressing using the content of another cell. | Excel Worksheet Functions | |||
Threaded Mode
