P
philtyler
I imported a database from !ACT to excel which included a phone# column
I need to sort the column but many of the phone numbers have the area
code in parentheses (207)-555-1234 so they sort seperately from
207-555-1234.
The problem is when I try to edit the phone# in the cell the ( )
disappears. They aren't in the formula bar either so I can't fix the
problem.
Formatting the whole column as phone numbers doesn't help.
I could retype them all but there are thousands.
Any suggestions why the cell would display and sort one way yet
actually contain something different when selected?
I need to sort the column but many of the phone numbers have the area
code in parentheses (207)-555-1234 so they sort seperately from
207-555-1234.
The problem is when I try to edit the phone# in the cell the ( )
disappears. They aren't in the formula bar either so I can't fix the
problem.
Formatting the whole column as phone numbers doesn't help.
I could retype them all but there are thousands.
Any suggestions why the cell would display and sort one way yet
actually contain something different when selected?