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

N

Norine

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.
 
N

Norine

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.
 
J

Jon Peltier

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
 
Top