View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
g.vanlaeke g.vanlaeke is offline
external usenet poster
 
Posts: 2
Default 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