Sunday, December 17, 2017

yogi_Troubleshoot Problem With Formatting Of Dates As dd/mm/yyyy

Google Spreadsheet   Post  #2322

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Dec-17-2017

"Date" field displays text and not digits


My date fields say "Day/Month/17", rather than the digits I have inputted into the cell, eg, "27/11/2017".

I have changed the spreadsheet's country to Australia so that the format should be DD/MM/YYYY.
I have also formatted the cells with this kind of date.

When I double click the cell, it does actually change back to the number's I've inputted and displays the calendar, but as soon as I click out of the cell it goes back to "Day/Month/17".

Please help!