ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel rounds up, then in mail merge uses nonrounded data (https://www.excelbanter.com/excel-discussion-misc-queries/68238-excel-rounds-up-then-mail-merge-uses-nonrounded-data.html)

Tboz

Excel rounds up, then in mail merge uses nonrounded data
 
I'm merging from excel 2003 to word 2003. The data in excel is rounded to a
..xx setup. I merge it to word and it goes to a .xxxx format for numbers that
don't come to a .xx in excel. How do I force excel to use the .xx data and
make that the data in the cell and not "hide" the .xxxx behind the showing
..xx in the cell??


All times are GMT +1. The time now is 06:53 PM.

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