\#0.00 mail merge decimal number (1 Viewer)

[zezo2021]

\#0.00​

MERGEFIELD GOEB_3\#0.00

mail merge from excel to I word

I put this code beside the number to remove unwanted decimal number to 2

The code work on the windows system

but not work on the Mac operating system

based on client

for example
this number show correctly on windows
104.30


but in mac
display wrong

1.04

 

[zezo2021]

up

 

[arnelgp]

i think majority here uses windows office.
it is better to post on mac forums.

 

[Pat Hartman]

Not sure where your data is coming from but the easiest solution is to use a query. In the query, you can format the the amount field to have only two decimal places.
Select fld1, fld2, fld3, Format([fld4], "Fixed") as FormattedFld4, fld5
From your table
Where something = Forms!someform!somevalue