Skip to content

Instantly share code, notes, and snippets.

@mixxorz
Created April 24, 2020 21:43
Show Gist options
  • Save mixxorz/f47df05e468233300255c79eff18fddf to your computer and use it in GitHub Desktop.
Save mixxorz/f47df05e468233300255c79eff18fddf to your computer and use it in GitHub Desktop.
World of Warcraft: Google Sheet custom number format for gold
Format: [>9999999999]###\,###\,###"g "##"s "#0"c";[>9999999]###\,###"g "##"s "#0"c";#0"g "00"s "00"c";
How it looks
0g 00s 00c
0g 00s 12c
0g 01s 23c
0g 12s 34c // Does not support hiding silver/copper
1g 23s 45c
12g 34s 56c
123g 45s 67c
1,234g 56s 78c
12,345g 67s 89c
123,456g 78s 90c
1,234,567g 89s 01c
12,345,678g 90s 12c
123,456,789g 01s 23c
1234,567,890g 12s 34c // Breaks on values greater than 1B gold
Alternative: [>9999]###"g "##"s "#0"c";[>99]##"s "#0"c";#0"c"
Display:
1c
12c
1s 23c
12s 34c
1g 23s 45c
12g 34s 56c
123g 45s 67c
1234g 56s 78c // No commas
12345g 67s 89c
123456g 78s 90c
1234567g 89s 01c
12345678g 90s 12c
123456789g 01s 23c
1234567890g 12s 34c
Unfortunately, Google Sheets does not allow you to have more than two conditionals so this is the best I could come up with.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment