"Hemming" wrote in
message ...

can anyone help me with this ,,,,it is driving crazy !! thanks
If you have to change them all to the same area code and exchange, I'd use
this formula in another column:

if cell A1 is: 5555555555
put this in cell A2: =value("444444" & right(a1,4))

Then you get a number in A2, which you can format as a Phone Number (using
Format/Cells/Number/Special/Phone Number).

HTH,

Don



--
Hemming
------------------------------------------------------------------------
Hemming's Profile:
http://www.excelforum.com/member.php...o&userid=32185
View this thread: http://www.excelforum.com/showthread...hreadid=519308