AsioOtus
-
Posts
168 -
Joined
-
Last visited
Community Answers
-
AsioOtus's post in Excel formula help 2 was marked as the answer
Found it, I didn't explain I was also trying to suppress zeros. Excel does it automatically by default and I'd just messed it up trying to be too clever, but you can combine the standard setting and still suppress zeros.
Number format > General;(General);"-"
Sorry to waste your time!