Excel - Abbreviate [Number] Billions to [#] Bn

Asked By Jaro on 01-Aug-08 03:43 PM
I have a sheet that has very large numbers.  What I need to do is condense
these numbers from their full format to something smaller

Example: 2,500,000,000 to 2.5B

I tried editing the number "custom" to:


with a decimal after the #, but the decimal just gets put to the end.




James_Thomlinso replied on 01-Aug-08 04:12 PM
Perhaps

which results in 2.5 B
or
which results in 2.5B as per your request

--
HTH...

Jim Thomlinson
JM replied on 01-Aug-08 04:14 PM
try

0.0,,," B"
RagDyer replied on 01-Aug-08 04:58 PM
Try this:

0.#,,, B

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------