You can change the date & time format in Google Sheets & Excel Online using this guide. Use different date & time formats in spreadsheets.

These two keyboard shortcuts will let you insert the current date and time in any cell of your spreadsheet. It doesn’t matter if you are using Google Sheets or Microsoft Excel; you can use these ...