Forum Discussion
Statement of cash flows in excel
Hello, i have instructions to replace any value that is 0.0% or less with a dash (-). Is there a formula to correctly format this? I do not want to lose points for simply manually entering the dash sy...
Hi Dakota,
Just follow the below steps, but these steps are applied to Excel for Windows, and it's not very different in Mac.
Step 1
Highlight the range of cells and press Ctrl+1.
Step 2
Select Custom Category.
Step 3
In the type text box, type this format:
_(* #,##0.00_);_(* "-"_);_(* "-"_);
Then hit OK.
This is shown in the screenshot below.
But please note that this is just a format or cover for the cells, and doesn't change their actual value.
If you want to change the actual value, use this formula:
=IF(A1<=0,"-",A1)