I've found a problem doing custom formats for a cell in that the semicolon is
used as a separator for the positive/negative/zero/text fields, and it's used
as a separator for conditionals like [100]#;[<100]"N/A", so I'm unable to
figure out how to do something like this (which doesn't work):

[=1000000]$0.0,,"M";[=1000]$0,"K";[<=-1000000]$0.0,,"M";[<=-1000]$0,"K"

How do you implement mulitple conditions for both positive and negative
numbers?

--
Lance Roberts
Control Systems Engineer
Golden Valley Electric Assoc.