Thanks Tom,

Your right, things are complicated enough as it is.

Doug


"Tom Ogilvy" wrote in message
...
or simpler

telephone = Cells(2,3).Text

No use repeating yourself. <g

--
Regards,
Tom Ogilvy

"Doug Glancy" wrote in message
...
Matt,

telephone = Format(Selection, "+# (###) ### ####")

hth,

Doug


wrote in message
oups.com...
Hello All,

I am using a script to take a list of phone numbers formatting them and
then doing a search with the phone number. I need to use the formatted
phone number to do the search.

Cell(2,3) before code is 12345678901
after code is +1 (234) 567 8901
Code Snippet:

Dim telephone as String
Columns("C:C").Select
Selection.NumberFormat = "+# (###) ### ####"
telephone = Cells(2,3).Value

End Code

The problem is that the variable "telephone" is equal to 12345678901
not the formatted +1 (234) 567 8901. Is there a way to convert the
formatted number into a string in VBA?

Excel 2003 VBA

Thanks in advanced
Matt