ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Merging excel into word (https://www.excelbanter.com/excel-discussion-misc-queries/195446-merging-excel-into-word.html)

Sarah

Merging excel into word
 
I am tring to merge an excel spreadsheet into word and there is $ in it so
when I do the decimal place changes.
It looks like this in excel $93.56 and in word it will look like
93.560000002 .
It is not all of them just some. The format in excel is fine and I can't
figure out what is going on. Can someone please help me?

dlw

Merging excel into word
 
it looks like you will have to round the number in excel, or change it into a
string before merging into word

"Sarah" wrote:

I am tring to merge an excel spreadsheet into word and there is $ in it so
when I do the decimal place changes.
It looks like this in excel $93.56 and in word it will look like
93.560000002 .
It is not all of them just some. The format in excel is fine and I can't
figure out what is going on. Can someone please help me?



All times are GMT +1. The time now is 01:54 AM.

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