| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Adding Custom Number Categories
Apologies if this has been asked before (I have tried searching)... What I would like is for #,##0_);[Red](#,##0) to appear as an option in the format cell custom number category for any worksheet that I open - rather than having to type this in each time I create a new sheet. Is this possible? If so how? Cheers! -- andikins ------------------------------------------------------------------------ andikins's Profile: http://www.excelforum.com/member.php...o&userid=19920 View this thread: http://www.excelforum.com/showthread...hreadid=469553 |
|
#2
|
|||
|
|||
|
creat an icon linked to a macro that formats the cell as desired -- dziw ------------------------------------------------------------------------ dziw's Profile: http://www.excelforum.com/member.php...o&userid=10422 View this thread: http://www.excelforum.com/showthread...hreadid=469553 |
|
#3
|
|||
|
|||
|
dziw Wrote: creat an icon linked to a macro that formats the cell as desired Thanks Olivier I could do that it's true but I was wondering if there would be a way of permanently adding formats to the custom number categories - as there are several formats I would like to use. Also not sure if the same macro would work for e.g. updating the format of an item in a pivot table? -- andikins ------------------------------------------------------------------------ andikins's Profile: http://www.excelforum.com/member.php...o&userid=19920 View this thread: http://www.excelforum.com/showthread...hreadid=469553 |
|
#4
|
|||
|
|||
|
Can anyone help? -- andikins ------------------------------------------------------------------------ andikins's Profile: http://www.excelforum.com/member.php...o&userid=19920 View this thread: http://www.excelforum.com/showthread...hreadid=469553 |
|
#5
|
|||
|
|||
|
You could try creating a new book.xlt template. Save it in your XLStart
folder. Include all the number formats you want in that workbook. When you click the new icon on the standard toolbar, excel will use that as the template for the new workbook. andikins wrote: Can anyone help? -- andikins ------------------------------------------------------------------------ andikins's Profile: http://www.excelforum.com/member.php...o&userid=19920 View this thread: http://www.excelforum.com/showthread...hreadid=469553 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Number of labels on X-axis one more than number of values on Y-axi | Charts and Charting in Excel | |||
| custom cell number | Excel Worksheet Functions | |||
| Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
| Adding a number to a date as workdays | Excel Worksheet Functions | |||
Hybrid Mode
