user form - format a phone number word 2007
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
"Dcook" wrote in message
...
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
|