PDA

View Full Version : Mailmerge rounding numerical values related problem



mbbx5va2
07-21-2014, 12:03 PM
Hi

So I've done a mail merge and put \#0.00x into the merge field where I need it to be in the form 0.00 for a cost of a product. Once the letters are populated the number comes up as £ 7.56 for 7.555555555555 which is what I want except for the space before the 7 in £7.56.

If I put in \#0.0x then it comes up as £ 7.6.

Any ideas? :think:

Thanks

gmaxey
07-21-2014, 12:27 PM
Try: \# "0.00"

mbbx5va2
07-21-2014, 01:33 PM
Try: \# "0.00"

Many thanks this works! :bow: