It is quite tricky to set custom number formats for a given cell in Google sheets. The way number formats are defined is explained here in the dropdown Custom number formatting. I wanted to use custom currency formats for several sheets  [ Read More ]