Rounding up numbers into millions

R

Rose

Is there a preset format option that would take off 3 or 6 decimal places (to
show a number in thousands or millions), or do I need to create a calculation?
 
S

Steve Huff

Are you just wanting to drop the decimal places? So for example show 1234
versus 1234.567 or even 1234.789564?

If so:

Format(12345.345,"#")

would give you: 12345

-Steve
 
R

Rose

No - I mean displaying 36,555,343 as 37 or 36.6.

Steve Huff said:
Are you just wanting to drop the decimal places? So for example show 1234
versus 1234.567 or even 1234.789564?

If so:

Format(12345.345,"#")

would give you: 12345

-Steve
Click to expand...
 
S

Steve Huff

You'd have to do part calculation part function:

Round(36555343*.000001,1) would give you 36.6

You can see from there how to get 37 and so forth...
 
Top