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
 

Thread Tools
Display Modes


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 04:37 AM.


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