ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   fig from excel not correct decimal place when merged. In word (https://www.excelbanter.com/excel-discussion-misc-queries/236782-fig-excel-not-correct-decimal-place-when-merged-word.html)

eddieba

fig from excel not correct decimal place when merged. In word
 
While merging a figs from excel the decimal point format does not hold eg.

10753.20 becomes 10753.199999999

David Biddulph[_2_]

fig from excel not correct decimal place when merged. In word
 
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/as...164951033.aspx
a.. http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm
a.. news:microsoft.public.word.mailmerge.fields
--
David Biddulph

"eddieba" wrote in message
...
While merging a figs from excel the decimal point format does not hold eg.

10753.20 becomes 10753.199999999





All times are GMT +1. The time now is 08:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com