Hi experts
I have a number format that shows thousands of dollars as follows: #,###, ;[Red](#,###,);-
It works great except for numbers greater than 0 and less than 500. In that case it shows a blank cell. Is there a way to write the format to keep the numbers as they currently are, ie. no $ symbol, commas to separate the thousands, etc. but to show either "-" or "0" if the numbers are in the 0-500 range?
Bookmarks