Excel number formats with brackets in all workbooks

Part 2 of our guide is now available on the Excel community site and looks at displaying to thousands and millions and using comparison operators in custom number formats:

[>=500]#,##0,_);[Red][<-500](#,##0,);-_)

In addition we consider how best to make your favourite number formats generally accessible using macros, Excel styles and templates:

This blog is brought to you by the Excel Community where you can find additional blogs, extended articles and webinar recordings on a variety of Excel related topics. In addition to live training events, Excel Community members have access to a full suite of online training modules from Excel with Business. There is also an online forum where you can ask questions and share ideas with other community members.

Anonymous