I have a custom format: [>500]_(* #,##0,_);[<-500]_(* (#,###,);_(*
"-"_);_(@_). This does the job fine for values between 0 and 500 which

shows "-", but, if the number is between -1 and -500 on the sheet, the
result is "- -". And all I want is the "-" like you get when you
select Accounting number format. I am trying to figure out how/why
this is happening, any ideas? Solutions?


Thanks,
Jon