Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Best way to format
All,
I have a model with almost 40 sheets. I want to toggle just the numbers between thousand and millions. And if it is millions I want to have one decimal point. Whats the best way to format this. Thanks much for your help. RK |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Best way to format
The best way is to create a style (Format-Style) and define the numeric
format there. Apply it faithfully, FAITHFULLY, to all your numeric values. If you want to change the format from thousands to millions, simply change the style's definition and it will flow through to all the cells to which that style has been applied To format as thousands use _(#,##0.0,_);(#,##0.0,) For millions with one decimal, use _(#,##0,,_);(#,##0,,) "rk0909" wrote: All, I have a model with almost 40 sheets. I want to toggle just the numbers between thousand and millions. And if it is millions I want to have one decimal point. Whats the best way to format this. Thanks much for your help. RK |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Best way to format
Thanks Duke. works great.
One additional question. is there an easy way to apply styles to multiple ranges using VBA. I am thinking of defining all the ranges and applying "Millions" style or "Thousands" style depending on what user selects on a cell. But for this I will have to define all the ranges in my model which have numerical values. Thanks a lot again. RK "Duke Carey" wrote: The best way is to create a style (Format-Style) and define the numeric format there. Apply it faithfully, FAITHFULLY, to all your numeric values. If you want to change the format from thousands to millions, simply change the style's definition and it will flow through to all the cells to which that style has been applied To format as thousands use _(#,##0.0,_);(#,##0.0,) For millions with one decimal, use _(#,##0,,_);(#,##0,,) "rk0909" wrote: All, I have a model with almost 40 sheets. I want to toggle just the numbers between thousand and millions. And if it is millions I want to have one decimal point. Whats the best way to format this. Thanks much for your help. RK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
Adding time in 24 hour format to produce hours in decimal format | Excel Worksheet Functions | |||
Excel 2003. Custom format gets replaced by Special format. | New Users to Excel | |||
Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
how to format excel format to text format with separator "|" in s. | New Users to Excel |