Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Format value in word 2003 with mail merge
Hi all,
I'd like to insert value 11.95 (value in exel) in my word document. But in word in get 1.949999999 I tried with "Toggle Field Codes" { MERGERFIELD "amount" \ # ##0.00} to get only 2 decimals. But nothing change stil got 1.949999 If I put 11.52 it works fine (withouth Toggle Field Codes)... If somebody know about this it would be great. Thans in advance, Gaëtan |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Format value in word 2003 with mail merge
There should be no space between \ and # and it is Mergefield not
Mergerfield thus { MERGEFIELD "amount" \# ",0.00"} should give you what you need. However, there is no function here that will drop the leading digit of the number 11.95 to make it 1.95 or 1.949999999 You need to check the entry in your Excel data. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "g.vanlaeke" wrote in message ... Hi all, I'd like to insert value 11.95 (value in exel) in my word document. But in word in get 1.949999999 I tried with "Toggle Field Codes" { MERGERFIELD "amount" \ # ##0.00} to get only 2 decimals. But nothing change stil got 1.949999 If I put 11.52 it works fine (withouth Toggle Field Codes)... If somebody know about this it would be great. Thans in advance, Gaëtan |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Format value in word 2003 with mail merge
On 12 jan, 11:05, "Graham Mayor" wrote:
There should be no space between \ and # and it is Mergefield not Mergerfield thus { MERGEFIELD "amount" \# ",0.00"} should give you what you need. However, there is no function here that will drop the leading digit of the number 11.95 to make it 1.95 or 1.949999999 You need to check the entry in your Excel data. -- Graham Mayor - Word MVP My web sitewww.gmayor.com Word MVP web sitehttp://word.mvps.org "g.vanlaeke" wrote in message ... Hi all, I'd like to insert value 11.95 (value in exel) in my word document. But in word in get 1.949999999 I tried with "Toggle Field Codes" { MERGERFIELD "amount" \ # ##0.00} to get only 2 decimals. But nothing change stil got 1.949999 If I put 11.52 it works fine (withouth Toggle Field Codes)... If somebody know about this it would be great. Thans in advance, Gaëtan Thanks a lot it works fine. Br, Gaëtan |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge date from Excel 2003 to Word 2003 in same format | Mailmerge | |||
Losing phone # format from Access 2003 to Mail Merge | Mailmerge | |||
Keep mail merge format from 2000 when using 2003! | Mailmerge | |||
Bug in Word 2003 (mail merge & date format)? | Mailmerge | |||
Mail Merge date format problem with Word 2003 | New Users |