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?

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.

--

Graham Mayor - Word MVP

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


jco wrote:
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?

Dear Graham!

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

JCO

"Graham Mayor" wrote:

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.

--

Graham Mayor - Word MVP

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


jco wrote:
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?

You are welcome

--

Graham Mayor - Word MVP

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


jco wrote:
Dear Graham!

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

JCO

"Graham Mayor" wrote:

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.

--

Graham Mayor - Word MVP

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


jco wrote:
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?