| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need a custom format of this number 70226 to show it 02/26/07. | Excel Worksheet Functions | |||
| Custom Cell format to mimic time format | Excel Discussion (Misc queries) | |||
| Custom Format - show as decimal | Excel Discussion (Misc queries) | |||
| how do I custom format .0040 to show as 40 ? | Excel Discussion (Misc queries) | |||
| how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) | |||
Linear Mode
