Sunday, September 25, 2011

How to Change a Negative Currency Into Positive in Excel 2007


1. Select the cell range you would like to format or change on the spreadsheet. These should be the currency numbers you want to change. To select all the cells in the worksheet, right click and Select All or CTRL A.
2. Click on the 'Format' menu. Scroll down to 'Cells.'
3. Click on the 'Number' tab and select 'Currency' or 'Accounting' in the box. Select the currency symbol you want.
4. Select the display style for negative numbers in the 'Negative Numbers' box. You can also choose the number of decimal places you want to display in the cell.

Blogger news