| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I don´t view the value right after six decimal place in Excel | Excel Discussion (Misc queries) | |||
| Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| decimal place and merging to word doc. | Excel Worksheet Functions | |||
| excel validation to 1 decimal place | New Users to Excel | |||
Linear Mode
