user form - format a phone number word 2007

  • Thread starter Thread starter Dcook
  • Start date Start date
D

Dcook

I am so frustrated. I am creating a form and I want to force a phone number
format. Easy in Excel but cannot find it anywhere in word 2007. Please help
Thanks
 
Use the VBA Format function

Format(1234567890, "(###) ###-####")

will return

(123) 456-7890

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
 
Back
Top