How do I define thousands separator for a mergefield?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jco - 23 Sep 2005 23:15 GMT

I have a mergefield with numbers using the period character as a thousands
separator (eg. the value "one thousand" is stored as "1.000").

Trying to make an IF statement, I get problems with Word understanding the
value one thousand (1.000) as the number 1 (with 3 decimals):

I.e.
{ IF { MERGEFIELD L01b } > 400 ”Hi” ”” }
shows nothing if the L01b value is above one thousand.

Any suggestions as to how I can fix this?

Reply to this Message

Graham Mayor - 24 Sep 2005 06:28 GMT

You will need to have Windows regional settings configured to use a period
as a thousands separator, otherwise it is likely to be seen as a decimal
point. i.e. what you report to be happening. The alternative is to replace
the periods in the data file with whatever your regional setting has as
separator.

Signature

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

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

> I have a mergefield with numbers using the period character as a
> thousands separator (eg. the value "one thousand" is stored as
[quoted text clipped - 9 lines]
>
> Any suggestions as to how I can fix this?

Reply to this Message

jco - 24 Sep 2005 20:17 GMT

Dear Graham!

Thank you very much for your great helpfullness with all my questions! Your
advice has really been very helpful to me.

JCO

> You will need to have Windows regional settings configured to use a period
> as a thousands separator, otherwise it is likely to be seen as a decimal
[quoted text clipped - 15 lines]
> >
> > Any suggestions as to how I can fix this?

Reply to this Message

Graham Mayor - 25 Sep 2005 06:31 GMT

You are welcome :)

Signature

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

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

> Dear Graham!
>
[quoted text clipped - 30 lines]
>>>
>>> Any suggestions as to how I can fix this?

Reply to this Message

Rate this thread: