Is there a way I can format a number so that significant 0's and a letter are conditional?
I currently use:
?0"g" ?0"s" ?0"c" - which formats like so:
100000 = 10g 00s 00c
100010 = 10g 00s 10c
1000 = 0g 10s 00c
What I wish to have is a code that formats like so:
101010 = 10g 10s 10c
10000 = 10s
10 = 10c
100010 = 10g 10c
Is this possible?
Bookmarks