How do I custom format $11 to show $11,000,000?
 

Can anyone tell me how to custom format a cell to show $11 as $11,000,000?

How do I custom format $11 to show $11,000,000?
 

Try format number custom format

0",000,000"

HTH,
Barb Reinhardt

"Norine" wrote:

Can anyone tell me how to custom format a cell to show $11 as $11,000,000?

How do I custom format $11 to show $11,000,000?
 

Thank you so much. I tried several combinations and just couldn't come up
with one that worked. It was the " that I was missing.
--
Thank you


"Barb Reinhardt" wrote:

Try format number custom format

0",000,000"

HTH,
Barb Reinhardt

"Norine" wrote:

Can anyone tell me how to custom format a cell to show $11 as $11,000,000?

How do I custom format $11 to show $11,000,000?
 

Two more question on the same subject:
1. How would I custom format 11.2 to show 11,200,000? When I use the same
format as before, it comes out at 11,000,000 instead of 11,200,000.

2. How would I custom format 2.5 to show 2500? I tried a format simular to
the one for 11,000,000 0",000" but it rounded up and showed 3000 instead of
2500.
--
Thank you


"Norine" wrote:

Thank you so much. I tried several combinations and just couldn't come up
with one that worked. It was the " that I was missing.
--
Thank you


"Barb Reinhardt" wrote:

Try format number custom format

0",000,000"

HTH,
Barb Reinhardt

"Norine" wrote:

Can anyone tell me how to custom format a cell to show $11 as $11,000,000?

How do I custom format $11 to show $11,000,000?
 

You probably need an intermediate formula for these other cases. In #1,
multiply the value by 1000000 and apply #,##0 as your format. In #2,
multiply by 1000 and apply the same format or simply 0.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Norine" wrote in message
...
Two more question on the same subject:
1. How would I custom format 11.2 to show 11,200,000? When I use the same
format as before, it comes out at 11,000,000 instead of 11,200,000.

2. How would I custom format 2.5 to show 2500? I tried a format simular
to
the one for 11,000,000 0",000" but it rounded up and showed 3000 instead
of
2500.
--
Thank you


"Norine" wrote:

Thank you so much. I tried several combinations and just couldn't come
up
with one that worked. It was the " that I was missing.
--
Thank you


"Barb Reinhardt" wrote:

Try format number custom format

0",000,000"

HTH,
Barb Reinhardt

"Norine" wrote:

Can anyone tell me how to custom format a cell to show $11 as
$11,000,000?