Try this:

0.#,,, B

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jarod" wrote in message
...
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:

#,," B"

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