excel负数显示红色

excel负数显示红色

Microsoft Excel displays negative numbers with a leading minus sign by default. It is good practice to make negative numbers easy to identify, and if you’re not content with this default, Excel provides a few different options for formatting negative numbers.

Microsoft Excel默认情况下显示带负号的负数。 优良作法是使负数易于识别，如果您不满意此默认值，则Excel提供了一些用于格式化负数的不同选项。

Excel provides a couple of built-in ways to display negative numbers, and you can also set up custom formatting. Let’s dive in.

Excel提供了两种显示负数的内置方法，您还可以设置自定义格式。 让我们潜入。

One thing to note here is that Excel will display different built-in options depending on the region and language settings in your operating system.

这里要注意的一件事是，Excel将根据操作系统中的区域和语言设置显示不同的内置选项。

For those in the US, Excel provides the following built-in o