Change a decimal point (.) by coma (,)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Thomas - 17 Feb 2005 12:29 GMT

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.

Reply to this Message

Greg - 17 Feb 2005 12:44 GMT

Word's round function rounds >=.5 up and <.5 down. You will have to
force a round up by adding a constant.

Say "Test" is a bookmark value 12.24 use the formula

{=round(Test + .5,0) } round to 13
or
{=round(Test +.05,1) } to round to 12.3
and so on.

For the comma decimal separator, I think you will have to make changes
in your Windows Regional and Language Settings.

Reply to this Message

Thomas - 17 Feb 2005 13:23 GMT

Hi Greg,

Thanks for your quick response,
I did not understand exactly what to do.
Where I must have to put the MERGEFIELD.

Could you fit your example in this one? It should make it easier for me
{ MERGEDFIELD PVPIVA \#"0.00" }

I tried by:
{=ROUND { MERGEDFIELD PVPIVA \#"0.00" }+.5,2}
{=ROUND { MERGEDFIELD PVPIVA \#"0.00" +.5,2}}
{=ROUND { MERGEDFIELD PVPIVA +.5,2}}
and others, but doesn´t work.

Thanks.

> Word's round function rounds >=.5 up and <.5 down. You will have to
> force a round up by adding a constant.
[quoted text clipped - 8 lines]
> For the comma decimal separator, I think you will have to make changes
> in your Windows Regional and Language Settings.

Reply to this Message

Graham Mayor - 17 Feb 2005 12:52 GMT

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.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hi all,
>
[quoted text clipped - 9 lines]
>
> Is urgent. Thanks.

Reply to this Message

Thomas - 17 Feb 2005 13:59 GMT

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.

> Word only Rounds -To round *up* you need a calculation
> { =ROUND({ ={ MERGEFIELD PVPIVA } + .005 },2) }
[quoted text clipped - 15 lines]
> >
> > Is urgent. Thanks.

Reply to this Message