Formatted Number into String Variable, Excel VBA

[mac7attack]

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

 

[Doug Glancy]

Matt,

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

hth,

Doug

 

[Tom Ogilvy]

or simpler

telephone = Cells(2,3).Text

No use repeating yourself. <g>

 

[Doug Glancy]

Thanks Tom,

Your right, things are complicated enough as it is.

Doug