Mail Merga Calculation doesnt work using "," as decimal separator.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ManuelB - 24 Mar 2006 17:36 GMT

I'm Creating a Mail Merge document, where the data source uses the latin
america decimal notation "," for decimals "." for thousands separator. All
the calulations on the docuemt such as {= ( {MERGEFIELD Edad} * 2) } get an
error : !Invalid Character Setting. Does Mail Merge Support this notation ?
If is switched to standard notation "." for decimals, "," for thousands it
works.

Manuel.

Reply to this Message

Doug Robbins - Word MVP - 24 Mar 2006 19:11 GMT

You probably need to change the settings under Control Panel>Regional and
Language Options>Customize Regional Options so the the separators match
those used in the data source.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> I'm Creating a Mail Merge document, where the data source uses the latin
> america decimal notation "," for decimals "." for thousands separator. All
[quoted text clipped - 6 lines]
>
> Manuel.

Reply to this Message

ManuelB - 26 Mar 2006 23:44 GMT

> You probably need to change the settings under Control Panel>Regional and
> Language Options>Customize Regional Options so the the separators match
[quoted text clipped - 10 lines]
> >
> > Manuel.

Hi Doug,

Thank you for your promopt reply, I'm doing exaclty that I'm changing the
setting s on control panel for the right setup of "," and ".". Data source
and Control Panel settings are in sync, but mail merge does'nt recognize the
value as numbers,

Kindly Regards,

Manuel

Reply to this Message

Doug Robbins - Word MVP - 27 Mar 2006 04:51 GMT

Send me a copy of the data source and I will take a look at the problem.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>> You probably need to change the settings under Control Panel>Regional and
>> Language Options>Customize Regional Options so the the separators match
[quoted text clipped - 28 lines]
>
> Manuel

Reply to this Message