数字格式，当数字为0的时候，能否显示为"-"？ #3878
Closed
shylock26
started this conversation in
Ideas | 产品建议
数字格式，当数字为0的时候，能否显示为"-"？
#3878
Replies: 2 comments
-
|
如果自定义格式能实现，该如何设置公式？ |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
没事了，我发现把excel里的格式复制过来就行了。_ * #,##0.00_ ;_ * -#,##0.00_ ;_ * "-"??_ ;_ @_ |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
数值为0的时候显示为“-”,这个是excel中千分符的显示格式。作为一名财务领域的从业人员，这样看着比较习惯。
Beta Was this translation helpful? Give feedback.
All reactions