Can you remove excess decimal places in Excel?

C

chris.todd.irandt

I use excel to work out formulations of products that we use. I have found
that although you can change the displayed figure to two decimal places it is
still representative of the whole figure. This is an accuracy not required by
us and causes problems on further formulating. Is there any function to
remove the excess decimal places? I.e. changing 38.8246346 to38.8200000?

Thanks
 
J

Jacob Skaria

Dear Chris

Format it to display 2 decimal digits. Go to Tools | Options | Calculation
and click on Precision as Displayed and click OK. Please note that this is an
application setting which will affect all workbooks. So you can revert this
once done..

If this post helps click Yes
 
J

Jacob Skaria

Dear Chris

Format it to display 2 decimal digits. Go to Tools | Options | Calculation
and click on Precision as Displayed and click OK. Please note that this is an
application setting which will affect all workbooks. So you can revert this
once done..

If this post helps click Yes
 

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

Set Decimal Places 3
reduce decimal places of number used in formula 2
A lot of Decimal Places 5
How can I change the default number of decimal places in Excel? 1
How do you remove excess spaces from an Excel field? 1
URGENT! errors when dealing with lots of decimal places 2
can you calculate sheet to 2 decimal places 1
Excel dropping decimal places 7

Top