Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rounding of 1000's
The rounded value is good enough.
Thanks for the tip "Tom Ogilvy" wrote: You can also do a custom cell format if you want to retain the original value #,000,.0 will produce the same as you formula, but in the cell If you don't want to see the decimal, then just #,000, -- Regards, Tom Ogilvy "MTechG" wrote: Never mind I answerd my own question I saw something Tom O had posted and modified it and it worked. =ROUND(D4/0.25,0)*0.25 I changed it to rCell =ROUND(D4/1000,1) "MTechG" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding of 1000's | Excel Programming | |||
VBA code to populate 1000's of cells? | Excel Discussion (Misc queries) | |||
my numbers go from 99 and then skip to 1000's? | Excel Discussion (Misc queries) | |||
Formatting in 1000's | New Users to Excel | |||
Formatting 100's and 1000's | Excel Discussion (Misc queries) |