\#0.00 mail merge decimal number (1 Viewer)

zezo2021

Member
Local time
Today, 19:56
Joined
Mar 25, 2021
Messages
231

\#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
 
Last edited:

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 01:56
Joined
May 7, 2009
Messages
16,490
i think majority here uses windows office.
it is better to post on mac forums.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 13:56
Joined
Feb 19, 2002
Messages
36,414
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
 

Users who are viewing this thread

Top Bottom