View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Can you remove excess decimal places in Excel?

=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