numbers in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Hi Jakob.

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

Note that subsequently unchecking this option will not restore the original
values.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for Duplicating Rows 3
Create a Macro to give movement to a graphic. 4
ie6 / hotmail 4
Auto rounding of large numbers 2
Excel Error when copying formulas 2
Excel 2003 -- how do I change a time format 3
text to numbers 1
Outline Numbering Format 2

Back
Top