4. Excel offers many other date format choices. In the cell format menu, click on "More Number Formats…" at the bottom. 5. In the window that pops up, make sure "Date" is chosen under the ...

How to change the date format in Google Sheets. 1. Log into your Google Docs account on your PC or Mac computer and create or open a spreadsheet.. 2. In your Google spreadsheet, select the cell(s ...

When you enter a date string, Excel formats it as a date using the date format, d-mmm-yy. Figure A. The date is an integer; time is a decimal value. A day equals 24 hours.