| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Thank you!!!
"Anne Troy" wrote: Right-click 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show text after formulas | Excel Discussion (Misc queries) | |||
| numbers being entered show in formula bar but not in cell? | Excel Discussion (Misc queries) | |||
| Separating dollars and cents | Excel Worksheet Functions | |||
| UDF and Calculation tree | Links and Linking in Excel | |||
| Show a date based on today | Excel Worksheet Functions | |||
Hybrid Mode
