I want to keep the values in the cells in plain metric units such that all formulas are the basic relations as would be found in a textbook, with no unnecessary, confusing, and mistake-prone constants in the formulas.

However, I want to *display* the values scaled to an easier to read order of magitude.

For division by powers of 1000, I can use commas, so I can use the format codes:

```
0.###,,,"G"
0.###,,"M"
0.###,"k"
0.###
```

Or I could even construct something more generic like this:

```
[>=1000000]0.###,,"M";[>=1000]0.###,"k";0.###
```

*(There seems to be a bug that prevents me from using more than 3 conditions, so for now G is omitted.)*

But for m, μ, n, etc., I cannot find a way.

I found this clever looking hack but the percents don’t seem to work properly: