Before you add any calculations or checkboxes, you need to tell Excel that certain ... to display the time and date together, click "Custom" in the Format Cells dialog box, and type dd/mm/yyyy ...

When you add a date, it uses a predefined ... To get started, you need to open a spreadsheet in Excel Online. Then, right-click on the date/time cell and select the Number Format option from ...

For example, Excel will automatically choose the date format for a cell that contains 11/11/19. You can set Excel to display dates in a variety of ways, no matter how you type in the data.