cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jpowers Frequent Visitor
Frequent Visitor

Zero Value Formatting

How do I get zeros to show as dashes like accounting formatting in excel?

3 REPLIES 3
Super User
Super User

Re: Zero Value Formatting

I am not aware of how kind of formatting, maybe using the FORMAT function?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Community Support Team
Community Support Team

Re: Zero Value Formatting

@jpowers,

 

You could add a calculated column.

Column =
IF ( Table1[Column1] = 0, "-", Table1[Column1] & "" )
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jpowers Frequent Visitor
Frequent Visitor

Re: Zero Value Formatting

This converts the numbers to text and then I am unable to sum.