Excel

Hi Eileen

Thank you for your question.

Excel will spot that the value you are entering is a date as soon as you press Enter or click somewhere else on the sheet.

You can modify the format used for your date by right clicking on it choosing Format Cells and from the Number tab choosing the date category. There you will find a selection of date formats that can be applied.

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew