00/01/1900 in MS Excel
30-Jan-1010 Leave a comment
00/01/1900 is zero i.e. 0 formatted as a date ‘dd/mm/yyyy’
Custom Formats in MS Excel accept multiple arguments, so if you want a 0 but formatted as a blank then use a custom format
dd/mm/yyyy;;
that’s 2 x ;; on the end, indicating put nothing if you get a zero
Stephen Shakespeare 