Home/ Questions/Q 929
Next
Answered
computing
  • 0
Asked: 2021-10-20T01:11:46+00:00 In:

How To avoid 1/1/1900 instead show blanks in dates in Excel.

  • 0

Formatting the whole column as mm/dd/yyyy;; will make it to show blanks instead of the 1/1/1900, to exclude in criteria >0

Alvaro Ortiz

Share

    1 Answer

    1. Best Answer
      Very neat trick, but not sure I see the value in using it.

      When you see 1/1/1900 in a Date cell that usually means an invalid value has been entered.
      If your doing a calculation, and the result will not be a Date, then perhaps the cell should not be formatted as a Date cell?

      Here is another way of doing the same thing, but this will display a Zero in the formula bar not 01/00/1900:

      Custom Format: [=0]””;General

      MIKE

      http://www.skeptic.com/

      • 0