E eddieba Jul 14, 2009 #1 While merging a figs from excel the decimal point format does not hold eg. 10753.20 becomes 10753.199999999
While merging a figs from excel the decimal point format does not hold eg. 10753.20 becomes 10753.199999999
D David Biddulph Jul 14, 2009 #2 You could use a helper column in Excel such as =TEXT(A1,"0.00") or use field formatting in Word: a.. http://www.mvps.org/dmcritchie/excel/mailmerg.htm a.. http://www.mvps.org/word/FAQs/MailMerge a.. http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx a.. http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm a.. -- David Biddulph
You could use a helper column in Excel such as =TEXT(A1,"0.00") or use field formatting in Word: a.. http://www.mvps.org/dmcritchie/excel/mailmerg.htm a.. http://www.mvps.org/word/FAQs/MailMerge a.. http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx a.. http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm a.. -- David Biddulph
