Rounding up numbers into millions

[Guest]

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?

 

[Guest]

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

 

[Guest]

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

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

 

[Guest]

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...