#1
|
|||
|
|||
Mail Merge, Number to 2 Decimal Places
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Saving INDV mail merges During the mail merge | sedain121 | Mail Merge | 2 | 10-04-2011 07:52 PM |
Mail merge number fields outputting inconsistently | rekcots | Mail Merge | 2 | 05-18-2011 06:32 AM |
My Places | lukewarmbeer | Office | 0 | 07-13-2010 02:33 PM |
Convert hours in decimal | ghostones | Excel | 1 | 12-29-2009 09:17 PM |
Merge, Too many Numbers right of the Decimal Point | ohdearme | Mail Merge | 0 | 10-25-2009 05:10 PM |