Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning a schedule to millions
Hi all,
I'm looking for suggestions on turning one of the schedules in my excel file to millions. This schedule mainly feeds from a pivottable using the getpivotdata function. I want the schedule to continue to be maintained in whole dollars, however a few of my end users are interested in seeing the same information presented in millions. My first thought is either a macro that would quickly interchange the dollars between whole and millions, or perhaps a mirrored schedule...I'd really perfer not to have to maintain two schedules whent it comes to adding and deleting rows of data and such. Thanks in a advance for any brainstorming you can throw at me :) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning a schedule to millions
How about just reformatting the numbers on the one sheet using a custom
format of 0.0,, "M" Which will turn 1,500,000 into 1.5 M -- HTH... Jim Thomlinson "JustBreathe" wrote: Hi all, I'm looking for suggestions on turning one of the schedules in my excel file to millions. This schedule mainly feeds from a pivottable using the getpivotdata function. I want the schedule to continue to be maintained in whole dollars, however a few of my end users are interested in seeing the same information presented in millions. My first thought is either a macro that would quickly interchange the dollars between whole and millions, or perhaps a mirrored schedule...I'd really perfer not to have to maintain two schedules whent it comes to adding and deleting rows of data and such. Thanks in a advance for any brainstorming you can throw at me :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I round Up to in Millions? | Excel Worksheet Functions | |||
Euro Millions | Excel Worksheet Functions | |||
I how do separate the millions? | Setting up and Configuration of Excel | |||
Rounding to millions | Excel Discussion (Misc queries) | |||
Create patient schedule based on master therapist schedule | Excel Discussion (Misc queries) |