Hi graham,
Still doesn't work right.
In the bd field I have the value 22.469999999999999 and after I make the
modifications you've indicated I didn't got 22.50 as I expected, but I can
get 23 or 22 easily without decimal places. This solves both problems for me,
rounding the value and avoiding any decimal character (point or coma).
Thanks you all.
Thomas.
"Graham Mayor" wrote:
Word only Rounds -To round *up* you need a calculation
{ =ROUND({ ={ MERGEFIELD PVPIVA } + .005 },2) }
You will have to change the regional settings of Windows to use a comma
decimal character.
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
Thomas wrote:
Hi all,
In word, I have a mergedfield pointing to an Access bd field where is
a number. Now I need to use comas (,) intead of points (.) as my
decimal character.
My mergedfield reads as follow: { MERGEDFIELD PVPIVA \#"0.00" } What
I need to change to use comas.
Also, I need to round up it. How can I do it in word? I need the
correct amount in access to avoid miscalculations.
Is urgent. Thanks.