 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / June 2005Troubleshoot using field switching to format phone numbers in Word
I used the following field switch to format a 10-digit phone number: {MERGEFIELD PHONE \# "(###) ###-####"} It worked in approx. 30% of the documents I merged. However, in the other 70%, it made a number that originally looked like this: 716662-5025, turn into: 71 1637. What did I do wrong??? I also tried removing the () and - from the mergefield, but the same thing happened. http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm Numbers need zeroes. So try {MERGEFIELD PHONE \# "(000) 000-0000"} ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com > I used the following field switch to format a 10-digit phone number: > [quoted text clipped - 5 lines] > I also tried removing the () and - from the mergefield, but the same thing > happened. It still didn't work. It gave me the same exact problem as before. Any suggestions? > http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm > [quoted text clipped - 16 lines] > > I also tried removing the () and - from the mergefield, but the same thing > > happened. I need to know what your source data looks like. Is it 10-digit numbers? Or are there other characters? ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com > It still didn't work. It gave me the same exact problem as before. Any > suggestions? [quoted text clipped - 19 lines] > > > I also tried removing the () and - from the mergefield, but the same thing > > > happened. The source data looks like: (716) 662-5025 in Excel. > I need to know what your source data looks like. Is it 10-digit numbers? Or > are there other characters? [quoted text clipped - 30 lines] > thing > > > > happened. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.