Word, Excel & Docs

Plus-Minus Symbol (±) in Word and Excel: Alt+0177, Alt+X 00B1 and Formatting

Insert ± in Word and Excel: Alt+0177 on the numeric keypad, 00B1 then Alt+X in Word, Insert Symbol, an AutoCorrect entry, Option+Shift+= on Mac, and Excel formulas and number formats that show ± while keeping the number.

By Blame Media Pty Ltd Updated Nov 16, 2026 3 min read

Copy the symbols in this guide

The plus-minus sign ± is a Windows-1252 character, so it has a real Alt code that works across Office: Alt+0177. Word also takes the Alt+X code 00B1, and Mac keyboards have it on Option + Shift + =. In Excel the interesting part is showing ± next to a number without breaking your formulas.

Quick answer

Where Fastest method
Word or Excel (Windows, numpad) Alt+0177
Word (Windows, no numpad) type 00B1, press Alt + X
Word or Excel (Mac) Option + Shift + =
Excel formula =UNICHAR(177)
Excel number with ± in front custom format “±“0.00
Word equation type \pm then a space
Anywhere copy ± from the top of this page

± in Word

Alt+0177 (Windows)

  1. Turn on Num Lock.
  2. Hold Alt and type 0177 on the numeric keypad.
  3. Release Alt. ± appears.

The leading zero matters: it picks the Windows-1252 table. Alt+241 (no zero, from the older CP437 table) also gives ± in most Windows apps. The number row above the letters does not work for either.

Alt+X (Windows)

Type 00B1 and press Alt + X. If the code follows a digit, as in 500B1, Word reads too many characters: type a space first, or select just 00B1 before pressing Alt+X. This works in Word and Outlook only.

Mac

Press Option + Shift + =. That works in Word, Excel and every other Mac app on the US keyboard layout. On other layouts, use the Character Viewer (Control + Command + Space, search “plus”).

Insert Symbol

  1. Windows: Insert → Symbol → More Symbols. Mac: Insert → Symbol → Advanced Symbol.
  2. Leave the font on (normal text). On Windows, type 00B1 in Character code.
  3. Click Insert.

Once used, ± sits in the Symbol drop-down for one-click reuse.

An AutoCorrect entry

Word has no built-in text shortcut for ±, but you can add one:

  1. Insert ± once and select it.
  2. Windows: File → Options → Proofing → AutoCorrect Options. Mac: Word → Preferences → AutoCorrect.
  3. Type +- in Replace (± is already in With because you selected it) and click Add.

Now +- followed by a space becomes ±. Pick a different trigger if you type +- for other reasons.

In an equation

Inside an equation (Alt + = on Windows, or Insert → Equation), type \pm and a space for ±, or \mp for the minus-plus sign ∓.

± in Excel

Typing it in a cell

Alt+0177 works in a cell on Windows, and Option + Shift + = on a Mac. Alt+X does not work in Excel. For a formula, =UNICHAR(177) returns ±.

Show ± and keep the number

If you type ±2.5 into a cell, Excel stores text and the value drops out of sums and charts. A custom number format adds the sign for display only:

  1. Select the cells.
  2. Press Ctrl + 1 (Cmd + 1 on Mac) and choose Number → Custom.
  3. In Type, enter "±"0.00 and click OK.

The cell shows ±2.50 and still holds 2.5. Change 0.00 to 0.0 or 0 for fewer decimals, or use "± "0.00" mm" for a tolerance with units.

Mean ± deviation in one cell

To build a label such as 12.4 ± 0.8 from two cells:

=TEXT(B2,"0.0")&" ± "&TEXT(C2,"0.0")

The result is text, which is fine for a report table. Keep B2 and C2 as numbers for any calculation.

Error bars in charts

A chart’s ± range is not a character: select the chart and use Chart Design → Add Chart Element → Error Bars to show it graphically.

Troubleshooting

  • Alt+0177 types nothing. Num Lock is off, or you used the number row. Use Alt+X in Word, or Option + Shift + = on a Mac.
  • Excel will not add up the ± cells. They are text. Remove the ± from the cell contents and apply the custom number format instead.
  • Alt+X turned my number into another character. The digits before the code were read as part of it. Select only 00B1 and press Alt+X again.

For ± outside Office (phones, Google Docs, HTML), see how to type the plus-minus sign. The plus-minus symbol page has every code. For other characters in Word, see how to insert symbols in Word.

Frequently asked questions

What is the Alt code for ± in Word and Excel? +

Alt+0177. Turn on Num Lock, hold Alt, type 0177 on the numeric keypad and release Alt. It works in Word, Excel, PowerPoint and Outlook on Windows.

How do I type ± in Word without a numpad? +

Type 00B1 and press Alt + X. Word replaces the code with ±. On a Mac with the US keyboard layout, press Option + Shift + =.

How do I show ± in front of a number in Excel? +

Use a custom number format: Ctrl + 1 → Number → Custom, and enter "±"0.00. The cell shows ±2.50 but still holds 2.5, so formulas keep working.

How do I write mean ± standard deviation in an Excel cell? +

Join the two values as text: =TEXT(B2,"0.0")&" ± "&TEXT(C2,"0.0"). The result is text for display, so keep the original numbers in their own cells for calculations.

✓ Copied to clipboard