But my version of Excel (2008) DOES have the option of using brackets for negative numbers, in the 'Accounting' and 'Currency' format choices. No need for a lot of custom formatting. By the way, I for one disagree strongly with the notion of putting negative numbers in red in most cases. Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 More. Less You can display negative numbers by using the minus sign, parentheses, or by applying a red color (with or without parentheses). ![]() Alex If David's option is not available under Format>Cell>Number. This is a function of your Regional Settings in Windows OS. Start>Settings>Control Panel>Regional and Language Settings>Regional Options>Customize>Currency>Negative Currency Format. ![]() Click on drop-down arrow and select the ($1.1) Note: this is under the 'Currency' tab in Regional Options. Download save game naruto ultimate ninja heroes 3 psp. Computer networking basics in hindi pdf free. Changing under the 'Numbers' tab only does not do the trick. Apply and OK>Apply your way out. You will have to close Excel then re-open to see effects. Gord Dibben Excel MVP.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |