#1
|
|||
|
|||
Merge Field Ignoring Zeros
I have a merge document in MS Word 2007. The data form is in Excel. When it pulls any financial info over from the excel document it omits any zeros after the decimal point.
So for example, if I have 180.00 and 180.10 in excel it shows up in the merged word document as 180. and 180.1 instead of the correct numbers. I've tried changing the formatting in Excel to just "text" and it's still missing the zeros in word, so I assume the problem is on the word side. I'm using this as a merge code "{ MERGEFIELD amount \#,###.##} to try and force it to two digits after the decimal point. "amount" is the name of the field in excel. Is there a better merge code I could be using that would show the correct figure with the zeros in? Many thanks in advance. |
#2
|
||||
|
||||
Your field switch effectively says to only output non-zero decimals. If you use:
{MERGEFIELD amount \# ,0.00} you will get all decimals to two places, and amounts of one thousand and over with thousand separators.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Wonderful, that worked! Thank you Macropod, as always.
|
Tags |
excel 2007, merge field, word 2007 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Character Count in Merge Field | deddy | Mail Merge | 3 | 10-20-2011 02:20 AM |
Toggle Merge Field Code Help Please | tonywatsonmail | Mail Merge | 2 | 08-11-2011 07:06 AM |
confusion with merge and field codes | BluRay | Mail Merge | 5 | 03-29-2011 01:06 AM |
Merge field in header disappearing | Medievalguy88 | Word | 2 | 01-06-2011 08:19 AM |
Mail merge Field Code Manipulation | macjnr | Mail Merge | 0 | 09-10-2009 11:37 AM |