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

Tired of finding, copying, and pasting data into spreadsheets? With just a few lines of code, you can set up a self-updating spreadsheet in Google Sheets that fetches and stores data for you.