101 Microsoft Excel Tips eBook

TheExcelAddict.com
Microsoft Excel "Quick Tip"

Insert A Division Symbol In Excel 
(XL2000-XL2010)

Sometimes you may need to show a division symbol (÷) in your worksheet instead of the forward slash (/). I often use it in column headings and explanation notes (e.g. Net Returns ÷ Sales or C÷D).

Since Excel uses the forward slash (/) as the division operator in calculating formulas, you can use the division symbol only in text

To insert a division symbol, hold down the ALT key and type 0247. Then release the ALT key.

Note: You must use the numeric keypad, not the numbers on the top row of your keyboard.

Insert a division symbol in Excel

Next Tip>>>

Get my FREE Excel Tips Newsletter
"Spreadsheet Tips From An Excel Addict"

Subscribe now to 'Spreadsheet Tips From An Excel Addict' and start receiving these time-saving Excel tips



Copyright © All Rights Reserved by Francis Hayes (The Excel Addict)

Tags: microsoft, excel, 2010, 2007, 2003, 2002, 2000, division, symbol, divide, alt key,