Forum Discussion

Dakota Toler's avatar
Dakota Toler
Copper Contributor
Nov 19, 2017

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!
Formulas & Functions
tips and tricks
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Nov 20, 2017

    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)

     

     

Resources