Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatted Number into String Variable, Excel VBA
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract a number from a variable text string | Excel Discussion (Misc queries) | |||
Find a specific formatted string in a cell | Excel Worksheet Functions | |||
can i change a number formatted as positive to negative in Excel | Excel Discussion (Misc queries) | |||
how to get the number of days between two date formatted fields in vba for excel? | Excel Worksheet Functions | |||
setting a range variable equal to the value of a string variable | Excel Programming |