ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   numbers in excel (https://www.excelbanter.com/excel-discussion-misc-queries/3437-numbers-excel.html)

Jakob

numbers in excel
 
I would likke to keep the numbers as I have fomatted it and as I see it in
the program. Example: I have chosen 2 digits so that 1,3465 i s shown as
1,35. When I link to Word it is now imported ad 1,3465. I would likke to keep
it to 1,35.
Can you help me?
--
JD

Norman Jones

Hi Jakob.

Tools | Options | Calculation | Check the "Precision as displayed" option.

Note that subsequently unchecking this option will not restore the original
values.


---
Regards,
Norman



"Jakob" wrote in message
...
I would likke to keep the numbers as I have fomatted it and as I see it in
the program. Example: I have chosen 2 digits so that 1,3465 i s shown as
1,35. When I link to Word it is now imported ad 1,3465. I would likke to
keep
it to 1,35.
Can you help me?
--
JD





All times are GMT +1. The time now is 07:13 PM.

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