Monthly Archives: January 2013

Microsoft Excel – putting negative numbers in brackets

Rather than having negative numbers with a minus sign in front of them, some people prefer to put negative numbers in brackets. To do this, select the cell or range of cells to be formatted, then if using Microsoft Excel … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , | 28 Comments

Creating a custom sort in Microsoft Access

It is easy enough to do a custom sort in Microsoft Excel, but what about in Access. In Access, you can create a calculated field using IIf in order to be able to do so. As an example, if you … Continue reading

Posted in Microsoft Access, Microsoft Access 2007, Microsoft Access 2010, Microsoft Access 2013, Microsoft Access 2016 | Tagged , | 5 Comments