Perhaps
#.0,, "B"

which results in 2.5 B
or
#.0,,"B"
which results in 2.5B as per your request

--
HTH...

Jim Thomlinson


"Jarod" wrote:

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.