Can I show a number like 1,935,674,923 as 1.9B?

[Dave]

I would like to reformat 10- and 11-digit the numbers (e.g. like
1,935,674,923 as 1.9B). Can this be done?

 

[Bernard Liengme]

Custom format: 0.0,,,"B"
best wishes

 

[Bernie Deitrick]

Dave,

Use a custom format of

#.#,,,"B"

or

0.0,,,"B"

depending on how you want to show smaller numbers.


HTH,
Bernie
MS Excel MVP

 

[Lars-Åke Aspelin]

I would like to reformat 10- and 11-digit the numbers (e.g. like
1,935,674,923 as 1.9B). Can this be done?

Try the following Custom Number format:

0.0 "B"

Note: There are 3 spaces before "B".

Hope this helps / Lars-Åke

 

[ryguy7272]

Right-click > Format Cells > Custom Format > Type
#,##0.0,,,"B"

 

[Bernard Liengme]

This does not seem to work with US version of Excel. You just get the large
number with B added to the end. We need to use commas not spaces: 0.0,,,"B"
best wishes

 

[Eduardo]

Hi,
format the cell with custom format and enter

0.0,,, "B"

 

[Lars-Åke Aspelin]

This does not seem to work with US version of Excel. You just get the large
number with B added to the end. We need to use commas not spaces: 0.0,,,"B"
best wishes

Thanks for pointing this out.
I didn't notice that the OP had these "," in the number.

Don't think it has to do with the version of Excel though.
It is the "Digit Grouping Symbol" in the "Regional and Language
Options" settings of the computer OS that controls this.

So a general answer could be:
Use a custom number format like
0.0xxx"B" (where x is the Digit Grouping Symbol).

Lars-Åke

 

[Bernard Liengme]

I agree. I was being a bit vague when I said "North American version of
Excel". I should have send "those using commas to separate groups" I like
to use spaces in my own work but it's a hard sell this side of the Atlantic
Cheers
Bernard