PatDorCopper ContributorDec 02, 2019I have a column in a spreadsheet that is formatted "date" but it automatically converts it formulaWhen I type 12/2...it converts it to =12/2 and displays "1/6/1900"
1 ReplyReplies sorted by NewestRiny_van_EekelenPlatinum ContributorDec 02, 2019PatDor https://answers.microsoft.com/en-us/msoffice/forum/all/excel-automatically-puts-an-in-front-of-date/b405010c-c5e9-460d-91a2-268b14d2867b Would this help?
Riny_van_EekelenPlatinum ContributorDec 02, 2019PatDor https://answers.microsoft.com/en-us/msoffice/forum/all/excel-automatically-puts-an-in-front-of-date/b405010c-c5e9-460d-91a2-268b14d2867b Would this help?
