Thread: Rounding
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson Ken Johnson is offline
external usenet poster
 
Posts: 1,073
Default Rounding


elusiverunner wrote:

Thanks for your reply Ken, but the cells that require the lack of rounding
already has a formula in it. Is there a way I can merge this with other
formula?


Hi Steven,

What is that formula?

Or try...

=TRUNC(original formula without the =, 2)

Ken Johnson