How to Change a Negative Currency Into Positive in Excel 2007

Microsoft Excel is a spreadsheet application that is used across the financial, accounting and data analyst sectors to manipulate and analyze data. While the system is fairly intuitive, it takes some experience to become familiar with how to perform certain operations like formatting. Changing the formatting on a number--for instance, converting a negative currency into a positive currency--may be necessary for a presentation or calculation.

Instructions

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.

References

• Microsoft: Display Numbers as Currency