×
英语
很抱歉。本文没有你的语言版本。

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.

扩展你的 Office 技能
了解培训
抢先获得新功能
加入 Office 预览体验计划

此信息是否有帮助?

谢谢您的反馈!

谢谢你的反馈! 可能需要转接到 Office 支持专员。

×