Forum Discussion
jdgofman
May 06, 2018Copper Contributor
Date Format in Excel
On my wife's computer, if I format a cell as a "number" and specify it as a "Date" and I select the format MM/DD/YYYY and in that cell, I enter 2/27/2017 then that is what appears in...
Haytham Amairah
May 08, 2018Silver Contributor
Hi,
You will see this result (1/0/1900) if you apply the date format to a cell with a value of 0.