If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




Show Dollars in Millions
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! 
Ads 
#2




Rightclick the chart, and hit Chart Options. Go to the Scale tab, and
choose Show in Millions. ******************* ~Anne Troy www.OfficeArticles.com "morrowjr" > wrote in message ... > 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! 
#3




"morrowjr" > wrote in message
... > 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! 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 
#4




"Gordon" > wrote in message
... > "morrowjr" > wrote in message > ... > > 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! > > 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 > > Doh! Didn't see the "chart" bit...... 
#5




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 FormatCellsNumber 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" wrote: > 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! 
#6




Thank you!!!
"Anne Troy" wrote: > Rightclick the chart, and hit Chart Options. Go to the Scale tab, and > choose Show in Millions. > ******************* > ~Anne Troy > > www.OfficeArticles.com > > > "morrowjr" > wrote in message > ... > > 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! > > > 
#7




Thank you!!!
"Duke Carey" wrote: > 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 FormatCellsNumber 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" wrote: > > > 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! 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
show text after formulas  Shirley  Excel Discussion (Misc queries)  3  June 30th 05 09:19 PM 
numbers being entered show in formula bar but not in cell?  Jim in Florida  Excel Discussion (Misc queries)  2  May 13th 05 06:36 PM 
Separating dollars and cents  alison via OfficeKB.com  Excel Worksheet Functions  5  March 30th 05 11:08 PM 
UDF and Calculation tree  Ken Wright  Links and Linking in Excel  1  February 6th 05 04:58 PM 
Show a date based on today  DJ Dusty  Excel Worksheet Functions  2  November 12th 04 03:20 AM 