数字格式，当数字为0的时候，能否显示为"-"？ #3878
Closed
NicFTK
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
Uh oh!
There was an error while loading. Please reload this page.
-
数值为0的时候显示为“-”,这个是excel中千分符的显示格式。作为一名财务领域的从业人员，这样看着比较习惯。
Beta Was this translation helpful? Give feedback.
All reactions