Zeroes into -
I am trying to change the zeroes in my report to become '-'.
Can I accomplish the above with an If Statement?
Forum Discussion
Have you tried adding something like this in the Cell Format under Number Format? 0;-0;"-"? If you have a Custom Number Format, it follows the same formatting as Excel. Excel Custom Number Format offers 4 arguments. Argument 1 is for the Display of Positive Numbers, Argument 2 is for the Display of Negative Numbers, Argument 3 is for the Number Zero Format, and Argument 4 is for Text. There are plenty of links on this subject online.
Hope this helps
How would I transform my zeroes into dashes in OS though?