Download the featured file here: [ Ссылка ]
In this video I demonstrate how to solve a problem, where Excel displays an unwanted 1900 date: 1/0/1900 (US) or 0/1/1900 (UK). This problem occurs where Excel interprets a blank cell as equalling zero. I explore two ways of hiding the 1/0/1900 date with custom number formatting and another method which uses a formula.
Table of Contents:
00:00 - Introduction
00:41 - Custom number format method 1 (m/d/yyyy;;;)
01:47 - Custom number format method 2 ([=0]"";m/d/yyyy)
02:36 - Using the IF function
*************************************
------------------------
Ещё видео!