Hello All,
I mail merge with Word using Excel data source. I have three issues (all might be able to be solved with single correct switches) and I hope you can help:
1. Field A contains alphanumeric data (with decimal points), for example: ‘0.2’, ‘0.35 (T+1)’, ‘0.65’, ‘0.8’. The field is formatted as General in Excel. Strangely, the mail merged data (in Word), randomly produced more decimal places than expected. I hope to produce as they are in the data source, but they become ‘0.19999999999’, ‘0.35 (T+1)’, ‘0.65’, ‘0.799999999999’. How do I make sure they appear as shown in the data source?
2. Field B contains alphanumeric data, for example, ‘175’, ‘3,000’, ‘Undisclosed’. The field is formatted as Number, Use 1000 Separator. How do I make sure the comma is displayed for data such as ‘3,000’?
3. Field C contains alphanumeric data (numeric data with two decimal points), for example, ‘1.65’, ‘2345.54’, ‘n/a’, ‘-10.00’. The field is formatted as Number with 2 decimal place in Excel. I used ‘# 0.00’ switch in my mail merge field and works well from <1000 numbers. How do I make sure comma appears in numbers bigger than 1000 and '0.00' is used in place of 'n/a'?
I try to avoid doing formatting in Excel.
Thank you all in advance.
Regards
Rid
