• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. S

    Display 0 instead of blanks

    I found the following VBA code to sort the above issue: First select the cells then do: Selection.SpecialCells(xlCellTypeBlanks).Select Selection.FormulaR1C1 = "0"
  2. S

    Display 0 instead of blanks

    Hi, I have the following format that will be applied as part of a macro: "_-[$€-2] * #,##0.00_ ;_-[$€-2] * -#,##0.00 ;_-[$€-2] * ""-""??_ ;_-@_ " This is basically an accounting format with the euro currency. What I need to add to it though it something that will display a 0 instead of a...
Back
Top