Abbreviate [Number] Billions to [#] Bn
try
0.0,,," B"
"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.
|