Excel中的数字格式:显示%值,不与100相乘 [英] Number format in excel: Showing % value without multiplying with 100
问题描述
当我设置一个单元格的格式为%时,它自动将该值乘以100&显示值。所以 5.66
变成 566%
。
我想在列上应用%格式,但要保持与以前相同的值。我只想要%符号与价值一起显示。为了达到这个目的,我使用了下面的格式 0.00现在,我想要显示的是否定的值红色不带' - '符号(负号),值应该括在括号内。所以-5.66应该显示为(5.66%)的红色。
请帮忙
0.00 ## \%; [Red](0.00 ## \%)
自定义格式的第一部分是您发布的定义格式。分号之后的所有内容都是负数。 [红色]告诉Excel使负数红色和()确保负数在括号中。
When I set format of a cell as %, it automatically multiply the value with 100 & show the value. So 5.66
becomes 566 %
.
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##\%
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.
Please help
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##\%)
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屋!