Thursday, February 24, 2011

How to Type a Negative Number in MS Excel


1. Launch Microsoft Excel 2010.
2. Click on a blank cell.
3. Press the 'Minus' sign ('-') on the keyboard and immediately press the desired numbers on the keyboard. Press 'Enter,' 'Tab' or an arrow key to save the number, and move to an adjacent cell.
4. Right click on the cell with the negative number displayed. Click 'Format Cells' on the context menu.
5. Click the 'Number' tab and click the desired format name in the left column to display options for that particular number format. Click the desired options for the number on the right. The options will vary by the type of number format being used.

Blogger news