Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
OK, try
{ ={ MERGEFIELD Contribution }*100 \#0.0% } Both pairs of {} need to be the special field code braces that you can insert using ctrl-F9 - everything else is ordinary text. (That's assuming 0.153 should display as 15.3% ) Peter Jamieson "LaurieB" wrote in message ... Peter, We took the switch out and just used { MERGEFIELD Contribution }. Here are some of the different results that I copied from the merged document to he 0.153, 0.15, 0.25, 0.237083, 0.1122, 0.0. I hope this helps and I really appreciate your prompt assistance with this. -- LaurieB "Peter Jamieson" wrote: What do you see when you just have { MERGEFIELD Contribution } ? Peter Jamieson "LaurieB" wrote in message ... We tried using { MERGEFIELD mynumber \#0.0% } what happens is if the percentage is 13.3% it shows as 3.3%. we currently have { MERGEFIELD Contribution \# .00.0% }. For some reason they have a . in front of the 00. -- LaurieB "Peter Jamieson" wrote: If you use Alt-f9 to look at the underlying field code, what do you see? If you have something like { MERGEFIELD mynumber } try changing it to { MERGEFIELD mynumber \#0.0% } Peter Jamieson "LaurieB" wrote in message ... Using switches to format mergefields. Is there a way to not show a zero in a percentage field? Office Manager would like to show 13.3% ; in the case of 07.3% not have the 0 show. -- LaurieB |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Access 2003 ole object merge to Word 2003 | Mailmerge | |||
Automating Mail merge between Word 2003 and Access 2003 using VB.NET | Mailmerge | |||
Mail Merge - Word 2003 & Access 97 | Microsoft Word Help | |||
Mail merge - Word 2003/Access 2000 | Mailmerge | |||
Word 2003 and Access 2003 Mail Merge question | Microsoft Word Help |