Rounding of 1000's

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

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

Brexit, Morals and Finance 5
value is changing at the end of Call Sub 2
Excel crashes with event 1000 1
multiple database lookup 1
Help with SUMPRODUCT please : ) 5
AutoFilter: Loop Thru Visible Rows? 2
Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA) 7
Excel mm:ss strings and rounding up 2

Back
Top