View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
rookie07
 
Posts: n/a
Default numeric pictu formating merge field without rounding decimal digits?

hello,

i'm not very used to ms word and have a problem concerning formating a
merge field with a numeric picture...

my datasource is a ms access db, especially a numeric (double) field
which for example contains a value like: 9957,7992. in the mail merge
this value should be displayed as a currency value like: 9.957,79 USD
(i'm from europe/austria).
so i did something like this: {MERGEFIELD MyDBField \# "#.00,00
USD;(#.00,00 USD)"} in order to format this field.

so the big probelm i have ist the output: 9.975,80 USD was rounded but
i need the original value: 9.975,79 USD.

is anyone out there who can help me with this?

THANX!!!