Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-12-2015, 11:36 AM
AJ345 AJ345 is offline Switches disappear Windows 7 64bit Switches disappear Office 2013
Novice
Switches disappear
 
Join Date: Mar 2015
Posts: 3
AJ345 is on a distinguished road
Default Switches disappear

Hi, I'm trying to format a numeric mailmerge field.

After many tries, I got it to retain this:
{ MERGEFIELD \# $,0 ContribTotalAmount }

Now I'm trying to add the ".00"

I go into the field and change it to :
{ MERGEFIELD \# $,0.00 ContribTotalAmount }

I preview results, or toggle field codes, and he number appears without the decimal point and last two digits. I re-toggle and I'm back to:
{ MERGEFIELD \# $,0 ContribTotalAmount }



I've also tried:
{ MERGEFIELD \# $,0.00 \*MERGEFORMAT ContribTotalAmount }

Sometimes when I toggle the first time it works, but disappears when I do the merge.

This has happened with every field I've tried to format - dates, etc. I've tried it with and without quotes. After awhile, I get it to take, but I never know why. Please help!!
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Switches disappear Problems With MergeField Switches JennEx Mail Merge 56 04-28-2013 06:40 PM
Switches ilovemypuppy Word 2 02-08-2012 04:28 PM
Switches disappear Index switches cksm4 Word VBA 2 02-03-2011 07:21 AM
Mail merge switches Jan Collier Mail Merge 0 08-29-2010 06:06 AM
Command Line Switches Ringmaster Office 0 08-10-2010 06:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:38 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft