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?


--
LoganStallworth
------------------------------------------------------------------------
LoganStallworth's Profile: http://www.excelforum.com/member.php...o&userid=27561
View this thread: http://www.excelforum.com/showthread...hreadid=471534