Hi,

I have some numbers on a mail merge that I want to show to 2 decimal places, however if the second decimal place is a zero then the formula I use only shows to 1 decimal place.

The 2 formulas I have been using are below;

£{ MERGEFIELD "NUMBER" \# "#,##0.0x" }

£{ MERGEFIELD "NUMBER" \#0.0x }

Both formulas result in the same problem, see example below;

MERGEFIELD "NUMBER" is 102 let's say. Both formulas display the number as £102.0

If the number is 102.01 then it is correctly displayed as £102.01

These numbers are the results of formulas in Excel so the decimal places are more than to 2 places.

Thanks for any help in advance.

Luke