Thread: Format Phone Number Field VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tony tony is offline
external usenet poster
  
Posts: 313
Default 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)

Reply With QuoteReply With Quote