#1
|
|||
|
|||
result of merge field is incorrect
I have the following merge field from excell 2007 to word 2007.
[Mergefield "bank"\#"0,00"] but the result of this link is Always 0,00. Do anyone know what's going wrong? |
#2
|
||||
|
||||
Your mergefield code lacks some spaces that should be present:
{MERGEFIELD bank \# "0,00"} I assumes the "0,00" reflects the fact you're using a language setting with a ',' decimal separator. PS: Please don't hijack other peoples' threads by adding your issue as a new reply. Start your own thread instead.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
I also tried a dot '.' ( [Mergefield "bank"\#"0.00"] ) but this give de following result '000'. I never get the numbers from my excel with 2 decimales.
|
#4
|
||||
|
||||
Depending on your system's regional settings, you should be able to get the desired results with either:
{MERGEFIELD bank \# ",0.00"} or: {MERGEFIELD bank \# ".0,00"}
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Merge multiple row sql query result | chelios | Mail Merge | 1 | 05-23-2014 03:10 AM |
Form field calculation returning 2x correct result | Jschueller | Word | 1 | 08-20-2013 01:51 PM |
How to ignore a mail merge field if the field is blank | redzan | Mail Merge | 1 | 05-16-2013 08:34 AM |
Merge field source data field | kckay | Mail Merge | 4 | 03-25-2013 11:06 AM |
lost data after incorrect merge changes response | vthomeschoolmom | Word | 1 | 04-22-2012 04:08 PM |