Negative numbers aren't showing with parentheses in Excel

If you're using Excel and negative numbers aren't displaying with parentheses, you can change the way negative numbers are displayed. But if that doesn't work, or if the parentheses option ($1,234.10) isn't available, it's likely because an operating system setting isn't set properly. If you're using a Mac, make sure you use the App Store and update to the latest version of macOS. If you're using Windows, use one of the following solutions to change the negative number format. Keep in mind that changing the setting will affect all programs on your computer, not just Excel.

Change negative number formats in Windows

  1. Close Excel.

  2. From the Start menu, search for Control Panel, and open Control Panel.

  3. Under Clock, Language, and Region, click Change date, time, or number formats.

    Note: If you don't see Clock, Language, and Region, click Category in the View by menu at the top of the page.

  4. On the Formats tab, click Additional settings at the bottom.

  5. On the Numbers tab, for Negative number format, choose (1.1)

  6. On the Currency tab, for Negative currency format, choose ($1.1)

  7. Click OK, and then click OK again.

  8. Reopen Excel.

  1. Close Excel.

  2. Click Start > Control Panel.

  3. Under Clock, Language, and Region, click Change keyboards or other input methods.

    Note: If you don't see Clock, Language, and Region, click Category in the View by menu at the top.

  4. On the Formats tab, click Additional settings at the bottom.

  5. On the Numbers tab, for Negative number format, choose (1.1)

  6. On the Currency tab, for Negative currency format, choose ($1.1)

  7. Click OK, and then click OK again.

  8. Reopen Excel.

  1. Close Excel.

  2. Click Start > Control Panel.

  3. Under Clock, Language, and Region, click Change keyboards or other input methods.

    Note: In Classic View, double-click Regional and Language Options, and then click the Formats tab.

  4. On the Formats tab, click Additional settings at the bottom.

  5. On the Numbers tab, for Negative number format, choose (1.1)

  6. On the Currency tab, for Negative currency format, choose ($1.1)

  7. Click OK, and then click OK again.

  8. Reopen Excel.

  1. Close Excel.

  2. Click Start > Settings > Control Panel.

  3. Click Date, Time, Language, and Regional Options, and then click Regional and Language Options.

    Note: In Classic View, double-click Regional and Language Options, and then click the Formats tab.

  4. On the Formats tab, click Additional settings at the bottom.

  5. On the Numbers tab, for Negative number format, choose (1.1)

  6. On the Currency tab, for Negative currency format, choose ($1.1)

  7. Click OK, and then click OK again.

  8. Reopen Excel.

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×