| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Phone Number Field VBA
I have a field that I am placing a phone number into as:
1234567890 I want it to be formatted as (123) 456- 7890 How can I do that if my code is currently: wsPh.Range("G6") = wsMaster.Range("AS" & iRow + 0) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format Phone Number Field VBA
Try
wsPh.Range("G6").NumberFormat = "(000) 000-0000" wsPh.Range("G6").Value = wsMaster.Range("AS" & iRow + 0) "Tony" wrote: I have a field that I am placing a phone number into as: 1234567890 I want it to be formatted as (123) 456- 7890 How can I do that if my code is currently: wsPh.Range("G6") = wsMaster.Range("AS" & iRow + 0) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format a cell with a phone number - how? | Excel Discussion (Misc queries) | |||
| phone number format | Excel Worksheet Functions | |||
| phone number format | Excel Discussion (Misc queries) | |||
| Format change of phone number | Excel Discussion (Misc queries) | |||
| how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) | |||
Linear Mode
