View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MTechG MTechG is offline
external usenet poster
 
Posts: 6
Default Rounding of 1000's

I'm working with a Cum scrap calc sheet where in VBA I'm totaling parts and
parts scraped and the numbers get big fast. I'd like to have everything
rounded off in Thousands so if we produced 5040 parts I'd see 5 and if we
scraped 1240 parts I'd see 1.2 Is there a rounding formula that would do
this?

TIA