Divide Symbol on Keyboard in Excel: Use / for Formulas

Formulas & functions · Updated November 19, 2026

In Excel, the divide key for calculations is the forward slash (/): enter a formula such as =A1/B1 to divide the value in A1 by the value in B1. The ÷ symbol is useful for showing division in text, but Excel formulas use the slash, not ÷.

Which keyboard key divides in Excel?

On a standard US keyboard, the forward slash shares a key with the question mark. It is usually just to the left of the right Shift key. Press the key without Shift to type /; hold Shift and press it to type ?. A numeric keypad also has a separate division key marked /, which can be convenient when entering many calculations.

To start a calculation in a worksheet cell, type an equals sign, then the first value or cell reference, a forward slash, and the value or reference to divide by. For example, with the numbers 24 and 6 in A1 and B1, respectively, enter =A1/B1 in C1; the result is 4. Press Enter to complete the formula.

The key’s exact position can differ on non-US keyboard layouts. If the slash is printed on a different key, use the layout’s normal method for entering / or use the numeric keypad. The important character in the formula is the ordinary forward slash, not a backslash (\) or a ÷ character.

Enter a division formula step by step

Excel calculates division with the slash operator. A formula can divide constants, cell references, or a combination of the two. Cell references are usually more useful because the answer updates when the source values change.

  1. Select the cell where you want the result to appear.
  2. Type =, then select or type the cell containing the number to be divided.
  3. Type /, then select or type the divisor, which is the number you are dividing by.
  4. Press Enter. To revise the calculation, select the result cell and edit the formula in the formula bar or directly in the cell.

For example, with units sold in A2 and the number of days in B2, enter =A2/B2 in C2 to calculate average units per day. If A2 is 84 and B2 is 7, C2 returns 12. Change either input and Excel recalculates the answer. You can also type a fixed number in a formula, as in =A2/7, but a cell reference is easier to update if the divisor may change.

When filling the formula down a column, Excel normally adjusts relative references: copying the formula from C2 to C3 changes A2 and B2 to A3 and B3. If a reference must stay fixed, use dollar signs, such as $B$1. For instance, if every amount in column A should be divided by the fixed rate in B1, enter =A2/$B$1 in C2 before copying it down.

Typing the ÷ character for display

The division sign and the formula operator serve different purposes. If you want to write a note such as “12 ÷ 3 = 4” in a cell, use the ÷ character. If you want Excel to calculate a result, use / in a formula. Typing =12÷3 does not replace the normal division operator and will not work as an ordinary Excel division formula.

On many Windows keyboards, you can type ÷ by holding Alt and entering 0247 on the numeric keypad, then releasing Alt. This usually requires the numeric keypad and Num Lock; the number row above the letters is not a substitute for the keypad in the traditional Alt-code method. Because keyboard settings and applications can affect character entry, check the cell after typing it.

In Excel for Microsoft 365 on Windows, you can also insert the character from the ribbon: choose Insert > Symbol, locate ÷ in the symbol dialog (often under Mathematical Operators), and choose Insert. The exact dialog choices can depend on the selected font. On a Mac using a US keyboard layout, Option+/ commonly types ÷; keyboard layouts vary, so use the Character Viewer if that shortcut does not produce it. Excel for the web may not offer the same full symbol dialog as the Windows desktop app, so copying ÷ from another source is another option.

Make division results easier to read

Excel may display a division result as a decimal, a percentage, or a rounded value depending on the cell’s number format. Formatting changes how a value appears; it does not change the underlying calculation. If a result looks like 0.25 but you intended to show a percentage, select the result cell and choose Home > Number > Percent Style. The displayed value becomes 25%.

For a chosen number of decimal places, select the cell and use the increase or decrease decimal buttons in the Home tab’s Number group, or open the Format Cells dialog with Ctrl+1 on Windows. On Mac, use Command+1 to open Format Cells. If Excel shows a run of number signs (####), the column is often too narrow to display the formatted value; widen the column or choose a shorter number format.

For example, with total cost in A2 and item count in B2, enter =A2/B2 in C2 to calculate cost per item. If A2 is 19.99 and B2 is 4, the underlying result is 4.9975. Applying a currency format with two decimal places displays $5.00 (the currency symbol depends on the workbook’s regional settings). The stored value remains 4.9975, so later calculations can still use that precision.

Division by zero and other common problems

Excel returns #DIV/0! when a formula divides by zero or by a blank cell used as the divisor. Check that the divisor cell contains the intended nonzero number and that the formula points to the correct row or column. This error is a useful warning: Excel cannot calculate a finite quotient when the divisor is zero.

If a result cell should remain blank until a divisor is entered, with the numerator in A2 and the divisor in B2, enter =IF(B2=0,"",A2/B2). This checks for zero (a blank cell also compares as zero in this test) and returns an empty display in that case; otherwise, it performs the division. Use this deliberately: hiding the error can make missing or invalid input less obvious. If a formula has a different problem, such as text where a number is expected, this test will not correct it.

Other quick checks include:

  • Confirm the formula starts with =. Without it, Excel may treat the entry as text rather than calculate it.
  • Check that you typed /, not the backslash \ or the visual ÷ character.
  • Inspect the formula bar to verify the cell references and look for an accidental reference to a blank cell.
  • If Excel displays the formula itself instead of its result, check whether the cell is formatted as Text. Change it to General, then re-enter the formula. Also check that Show Formulas is not turned on; Ctrl+` toggles this view on Windows, while the shortcut can differ by Mac keyboard layout.

Division, QUOTIENT, and rounding

The slash operator returns the ordinary quotient, including any decimal portion. Excel also has a QUOTIENT function when you specifically need the integer portion of a division result. With 17 in A2 and 5 in B2, enter =QUOTIENT(A2,B2) in C2; it returns 3, discarding the remainder rather than displaying 3.4. This is not the same as rounding to the nearest whole number.

For most calculations, use / and decide separately how to display or round the answer. Formatting a cell to show zero decimal places changes the display but retains the more precise stored value. If you need the calculation itself rounded, use Excel’s ROUND function. With the quotient in A2, enter =ROUND(A2,2) in B2 to return that value rounded to two decimal places. Choose the method that matches the task: formatting is for presentation, while a rounding function changes the formula’s returned value.

Order of operations and parentheses

Excel follows standard arithmetic order: operations in parentheses are handled first, then exponents, then multiplication and division, followed by addition and subtraction. Multiplication and division at the same level are evaluated from left to right. As a result, a longer formula that mixes division with addition may not mean what you first expect.

With no cell references, enter =10+6/2 in any empty cell; Excel returns 13 because it divides 6 by 2 before adding 10. To divide the sum instead, enter =(10+6)/2; the result is 8. Parentheses make the intended grouping explicit and are especially helpful in formulas that combine several operations or when another person will need to review the worksheet.

Frequently Asked Questions

What is the divide symbol in an Excel formula?
Use the forward slash, /. For example, with the number to divide in A1 and the divisor in B1, enter =A1/B1 in the result cell.

Can I use ÷ instead of / in Excel?
No. Use / for a calculation formula. The ÷ character can be inserted in a label, explanation, or other text, but it is not Excel’s normal division operator.

How do I type ÷ on a Windows keyboard?
On many Windows setups, hold Alt and type 0247 using the numeric keypad, then release Alt. You can also use Insert > Symbol in the Windows desktop version of Excel, or copy and paste the character.

Why does my Excel division formula show #DIV/0!?
The divisor is zero or refers to a blank cell. Check the divisor and the formula’s references. If a blank result is appropriate until the divisor is supplied, use an IF check, but avoid hiding errors that need attention.

How do I divide a column of numbers by one fixed cell?
With the values in A2:A20 and the fixed divisor in B1, enter =A2/$B$1 beside the first value, then fill the formula down. The dollar signs keep B1 fixed while the A-row reference changes.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.