excel中的数字格式:显示百分比值而不乘以100 [英] Number format in excel: Showing % value without multiplying with 100

问题描述

当我将单元格的格式设置为 % 时，它会自动将该值乘以 100 &显示价值.所以 5.66 变成 566 %.

When I set format of a cell as %, it automatically multiply the value with 100 & show the value. So 5.66 becomes 566 %.

我想在列上应用 % 格式，但想保持与以前相同的值.我只希望 % 符号与值一起显示.为此，我使用了以下格式 0.00##\%

I want to apply % format on a column but want to keep the values same as before. I just want % sign to be shown along with the value. To achieve this, I used following format 0.00##\%

现在我想用没有'-'符号(负)的红色显示负值，并且值应该用括号括起来.所以 -5.66 应该以红色显示为 (5.66%).

Now I want to show negavtive values in RED color without '-' sign(negative) and the values should be wrapped in brackets. so -5.66 should be shown as (5.66%) in red color.

请帮忙

推荐答案

您只需更改为自定义格式 - 右键单击​​并选择格式，列表底部是自定义的.

You just have to change to a Custom format - right click and select format and at the bottom of the list is custom.

 0.00##\%;[Red](0.00##\%)

自定义格式的第一部分是您发布的定义格式.分号之后的所有内容都是负数.[RED] 告诉 Excel 将负数变为红色，并且 () 确保负数在括号中.

The first part of custom format is your defined format you posted. Everything after the semicolon is for negative numbers. [RED] tells Excel to make the negative numbers red and the () make sure that negative number is in parentheses.

这篇关于excel中的数字格式:显示百分比值而不乘以100的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！