101 Microsoft Excel Tips eBook

Microsoft Excel "Quick Tip"

Insert A Division Symbol In Excel 

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 CD).

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,