google-sheets - Google 表格 巧妙地将数字格式化为十亿/百万/千

Question

我有这个数字模板格式:

[>=999950]0.0,,"M";[<=-999950]0.0,,"M";0.0,"K"

但是我该怎么做才能让 Zeros 显示为“-”？

Answer 1

我认为你不能:

Conditions can only be applied to the first two sub-formats and if a number matches more than one, it will use the first one it matches. If there is a third format, it will be used for "everything else", otherwise if a number doesn’t match either format, it will be rendered as all "#"s filling up the cell width. The fourth format is always used for text, if it exists.

来源: https://developers.google.com/sheets/api/guides/formats#meta_instructions