Show Dollars in Millions

M

morrowjr

Is there a formula in Excel that changes a calculated dollar figure so that
it just shows in the 000,000's? For example, I have a calculated figure of
$15,806,375,100. However, in my chart, I just want to show $15,806. I there
a way for Excel to do this so that I don't have to type all my figures
manually? Thanks!
 
G

Gordon

morrowjr said:
Is there a formula in Excel that changes a calculated dollar figure so that
it just shows in the 000,000's? For example, I have a calculated figure of
$15,806,375,100. However, in my chart, I just want to show $15,806. I there
a way for Excel to do this so that I don't have to type all my figures
manually? Thanks!
Click to expand...

Set up a custom format of "###," (without the quotes, and the comma is
important!) That will show your example as 15806. Can't help with the
separator though! (This will round any figure up or down).

HTH
 
G

Gordon

Gordon said:
Set up a custom format of "###," (without the quotes, and the comma is
important!) That will show your example as 15806. Can't help with the
separator though! (This will round any figure up or down).

HTH
Click to expand...

Doh! Didn't see the "chart" bit......
 
D

Duke Carey

If it's calculated, you can amend the formula to divide by 1 million.

Alternatively, you can format the cell and the chart's scale to DISPLAY the
# rounded to millions. You just need a custom number format

If you are using Currency [0] now, simply select the cell with the value,
use Format|Cells|Number and select Custom from the left hand panel and then,
in the right hand panel you should see a string that looks like this

_($* #,##0_);_($* (#,##0);_($* "-"_);_(@_)

Change it to the following by adding 2 commas after each zero

_($* #,##0,,_);_($* (#,##0,,);_($* "-"_);_(@_)

Then click on OK. You'll also have to apply that format to the axis and/or
to the value
 
M

morrowjr

Thank you!!!

Duke Carey said:
If it's calculated, you can amend the formula to divide by 1 million.

Alternatively, you can format the cell and the chart's scale to DISPLAY the
# rounded to millions. You just need a custom number format

If you are using Currency [0] now, simply select the cell with the value,
use Format|Cells|Number and select Custom from the left hand panel and then,
in the right hand panel you should see a string that looks like this

_($* #,##0_);_($* (#,##0);_($* "-"_);_(@_)

Change it to the following by adding 2 commas after each zero

_($* #,##0,,_);_($* (#,##0,,);_($* "-"_);_(@_)

Then click on OK. You'll also have to apply that format to the axis and/or
to the value


morrowjr said:
Is there a formula in Excel that changes a calculated dollar figure so that
it just shows in the 000,000's? For example, I have a calculated figure of
$15,806,375,100. However, in my chart, I just want to show $15,806. I there
a way for Excel to do this so that I don't have to type all my figures
manually? Thanks!
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change Style to 'Keep with previous' instead of Keep with Next 1
Turning off automatic calculation 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
converting number to dollar 10
How to find and replace text in a document with changing variables 2
VBA word change keys 0
Financial Time Value of Money calculations 5
Access Lock File .LACCDB / Now shows as a notepad file 0

Top