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?

Custom format: 0.0,,,"B"
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Dave" wrote in message
...
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?

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


"Dave" wrote in message
...
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?

On Wed, 6 Jan 2010 09:16:02 -0800, Dave
wrote:

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

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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Lars-Åke Aspelin" wrote in message
...
On Wed, 6 Jan 2010 09:16:02 -0800, Dave
wrote:

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

On Wed, 6 Jan 2010 13:51:28 -0400, "Bernard Liengme"
wrote:

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

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

"Lars-Åke Aspelin" wrote in message
...
On Wed, 6 Jan 2010 13:51:28 -0400, "Bernard Liengme"
wrote:

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

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

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Dave" wrote:

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?

Hi,
format the cell with custom format and enter

0.0,,, "B"



"Dave" wrote:

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?