Custom Number Formats - Billion Dollars Rounded

  • Thread starter Thread starter coastal
  • Start date Start date
C

coastal

Ok. Thanks to the discussion group I was given the following custom
formatting setting so that I could round numbers.

[>=1000000000] $#,###,, "Billion";[>=1000000]$#,, "Mil"; $#, "k"

The above will formatt this $1,965,532 into this $2 Mil
But will also formatt this $1,838,928 into this $2 Mil

I need to adjust the custom number formatting so that I get the following
instead
$1.9 Mil
$1.8 Mil

Any suggestions?
 
coastal,

How about this?

[>=1000000000] $#,###,, "Billion";[>=1000000]$#.#,, "Mil"; $#, "k"

HTH,

Conan
 
woops,

I mean

[>=1000000000] $#,###,, "Billion";[>=1000000]$#.0,, "Mil"; $#, "k"

But 1,965,532 will round up to 2.0 mil because 60,000 is rounding up causing
900,000 to round up to the next mil

1,945,532 should round to 1.9 mil.

HTH,

Conan





Conan Kelly said:
coastal,

How about this?

[>=1000000000] $#,###,, "Billion";[>=1000000]$#.#,, "Mil"; $#, "k"

HTH,

Conan




coastal said:
Ok. Thanks to the discussion group I was given the following custom
formatting setting so that I could round numbers.

[>=1000000000] $#,###,, "Billion";[>=1000000]$#,, "Mil"; $#, "k"

The above will formatt this $1,965,532 into this $2 Mil
But will also formatt this $1,838,928 into this $2 Mil

I need to adjust the custom number formatting so that I get the following
instead
$1.9 Mil
$1.8 Mil

Any suggestions?
Click to expand...
Click to expand...
 
Just noticed your format for billion is wrong. It's formatting 1.5 Billion
as 1,500 Billion. Try this:

[>=1000000000] $#,##0.0,,, "Billion";[>=1000000]$#0.0,, "Mil"; $#, "k"

Tyro

Tyro said:
[>=1000000000] $#,###,, "Billion";[>=1000000]$#0.0,, "Mil"; $#, "k"

coastal said:
Ok. Thanks to the discussion group I was given the following custom
formatting setting so that I could round numbers.

[>=1000000000] $#,###,, "Billion";[>=1000000]$#,, "Mil"; $#, "k"

The above will formatt this $1,965,532 into this $2 Mil
But will also formatt this $1,838,928 into this $2 Mil

I need to adjust the custom number formatting so that I get the following
instead
$1.9 Mil
$1.8 Mil

Any suggestions?
Click to expand...
Click to expand...
 
Another thing:

1,838,928,000 will be displayed as $1,839 Billion, which is technically
incorrect. That would either be 1.8 billion or 1,839 million (sorry about
the nerdy anal-ness).

Thought I'd let you know. If it is for something official, you might want
to change that or it might look like your numbers are off by 3 decimal
places.

If it is just for yourself, just keep that in mind.

[>=1000000000] $#.0,, "Billion";[>=1000000]$#.0,, "Mil"; $#, "k"

will get you "$1.8 Billion"

[>=1000000000] $#,###,, "Million";[>=1000000]$#.0,, "Mil"; $#, "k"

will get you "$1,839 Million"

HTH,

Conan



Conan Kelly said:
woops,

I mean

[>=1000000000] $#,###,, "Billion";[>=1000000]$#.0,, "Mil"; $#, "k"

But 1,965,532 will round up to 2.0 mil because 60,000 is rounding up
causing 900,000 to round up to the next mil

1,945,532 should round to 1.9 mil.

HTH,

Conan





Conan Kelly said:
coastal,

How about this?

[>=1000000000] $#,###,, "Billion";[>=1000000]$#.#,, "Mil"; $#, "k"

HTH,

Conan




coastal said:
Ok. Thanks to the discussion group I was given the following custom
formatting setting so that I could round numbers.

[>=1000000000] $#,###,, "Billion";[>=1000000]$#,, "Mil"; $#, "k"

The above will formatt this $1,965,532 into this $2 Mil
But will also formatt this $1,838,928 into this $2 Mil

I need to adjust the custom number formatting so that I get the
following
instead
$1.9 Mil
$1.8 Mil

Any suggestions?
Click to expand...
Click to expand...
Click to expand...
 
That worked great!
--
--coastal


Conan Kelly said:
Another thing:

1,838,928,000 will be displayed as $1,839 Billion, which is technically
incorrect. That would either be 1.8 billion or 1,839 million (sorry about
the nerdy anal-ness).

Thought I'd let you know. If it is for something official, you might want
to change that or it might look like your numbers are off by 3 decimal
places.

If it is just for yourself, just keep that in mind.

[>=1000000000] $#.0,, "Billion";[>=1000000]$#.0,, "Mil"; $#, "k"

will get you "$1.8 Billion"

[>=1000000000] $#,###,, "Million";[>=1000000]$#.0,, "Mil"; $#, "k"

will get you "$1,839 Million"

HTH,

Conan



Conan Kelly said:
woops,

I mean

[>=1000000000] $#,###,, "Billion";[>=1000000]$#.0,, "Mil"; $#, "k"

But 1,965,532 will round up to 2.0 mil because 60,000 is rounding up
causing 900,000 to round up to the next mil

1,945,532 should round to 1.9 mil.

HTH,

Conan





Conan Kelly said:
coastal,

How about this?

[>=1000000000] $#,###,, "Billion";[>=1000000]$#.#,, "Mil"; $#, "k"

HTH,

Conan




Ok. Thanks to the discussion group I was given the following custom
formatting setting so that I could round numbers.

[>=1000000000] $#,###,, "Billion";[>=1000000]$#,, "Mil"; $#, "k"

The above will formatt this $1,965,532 into this $2 Mil
But will also formatt this $1,838,928 into this $2 Mil

I need to adjust the custom number formatting so that I get the
following
instead
$1.9 Mil
$1.8 Mil

Any suggestions?
Click to expand...
Click to expand...
Click to expand...
 
Thanks!
--
--coastal


Tyro said:
Just noticed your format for billion is wrong. It's formatting 1.5 Billion
as 1,500 Billion. Try this:

[>=1000000000] $#,##0.0,,, "Billion";[>=1000000]$#0.0,, "Mil"; $#, "k"

Tyro

Tyro said:
[>=1000000000] $#,###,, "Billion";[>=1000000]$#0.0,, "Mil"; $#, "k"

coastal said:
Ok. Thanks to the discussion group I was given the following custom
formatting setting so that I could round numbers.

[>=1000000000] $#,###,, "Billion";[>=1000000]$#,, "Mil"; $#, "k"

The above will formatt this $1,965,532 into this $2 Mil
But will also formatt this $1,838,928 into this $2 Mil

I need to adjust the custom number formatting so that I get the following
instead
$1.9 Mil
$1.8 Mil

Any suggestions?
Click to expand...
Click to expand...
Click to expand...
 
coastal,

How about this?

[>=1000000000] $#,###,, "Billion";[>=1000000]$#.#,, "Mil"; $#, "k"

HTH,

Conan




coastal said:
Ok. Thanks to the discussion group I was given the following custom
formatting setting so that I could round numbers.

[>=1000000000] $#,###,, "Billion";[>=1000000]$#,, "Mil"; $#, "k"

The above will formatt this $1,965,532 into this $2 Mil
But will also formatt this $1,838,928 into this $2 Mil

I need to adjust the custom number formatting so that I get the following
instead
$1.9 Mil
$1.8 Mil

Any suggestions?
Click to expand...
Click to expand...

Thank you for this...!!!

google people are smart people!
 
Back
Top