Format by "Value Unit" - Githubissues

WikiNewZealand / fundamental-figures

0 stars 0 forks source link

Format by "Value Unit" #8

Closed Spksh closed 5 years ago

Spksh commented 5 years ago

We can apply Excel formats to cells based on "Value Unit"

number
percentage (e.g. 21.3333333333 to 21.33%)

What others can we expect to see?

natdudley commented 5 years ago

I think only these two. The Value Label should also be displayed next to it.

However, if we do calculations on them (e.g. converting to %), this will impact the value label displayed and it will need to be changed or specified accordingly.

natdudley commented 5 years ago

Also nzd

Spksh commented 5 years ago

nzd: "$###,###,###,###,###,###,###,###,##0.00" percentage: "0.00%" after dividing by 100 number: "###,###,###,###,###,###,###,###,##0.##" or "###,###,###,###,###,###,###,###,##0"