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

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
---------------
Jacob Skaria


"chris.todd.irandt" wrote:

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

=round(a2,2)
--
David Biddulph

"chris.todd.irandt" wrote in
message ...
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