will this work?

="1" & SUBSTITUTE(A1,"-","")

--


Gary Keramidas
Excel 2003


"Dale" wrote in message
...
I am new to excel and I have a database that I am trying to convert to a
contact list. The phone number format is not compatable. I tried the "auto
correct" option in Tools after highlighting my column of numbers as well
as
the "find/replace" option under editing. Neither worked. Thanks
Dale