How to Change Positive Data to Negative on Microsoft Excel


Microsoft Excel is a spreadsheet application that is part of the Microsoft Office productivity suite. Spreadsheets contain rows and columns to hold data, usually numbers. You can create graphs, charts and reports from the data. Sometimes you need to enter negative numbers rather than positive data. Microsoft Excel provides multiple ways to format negative numbers.

  • Click "Start," "All Programs," "Microsoft Office" and then "Microsoft Excel 2010." Click "File" and "Open." Locate your file and click "Open."

  • Double-click the cell containing the number you wish to change from positive to negative. Enter the negative symbol before the first number and press "Enter."

  • Select "Number" from the drop-down list in the Number group of the Home tab of the ribbon bar. Click the expander arrow in the lower right of the Number group or "Alt," "H," "F" then "M" to show all the formatting options.

  • Select one of four options for displaying negative numbers on the Number tab. Click "OK."

  • Click "Conditional Formatting" > "Highlight Cell Rules" > "Less Than" to set conditional formatting. Enter "0" (zero) in the first box and select an option from the second. Click "OK."

Related Searches


  • Photo Credit Jack Star/PhotoLink/Photodisc/Getty Images
Promoted By Zergnet



You May Also Like

  • How to Track Employee Productivity

    When getting ready to initiate employee-tracking software or other devices, take into consideration the role you need it to play. Use perfromance-tracking...

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!