Forum Discussion
Dakota Toler
Nov 19, 2017Copper Contributor
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 symbol into all of the cells that require a dash. Thank you!
- Haytham AmairahSilver Contributor
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)