Using a date with 30 in the year

[jimfim]

Hi

I am using dates in excel out into 2030 and when you type 05/01/30 it writes the date as 05/01/1930.  Does anyone know of a fix instead of writing it in its long form?

Thanks

J

[#2]

Hi,
You've posted your topic in "Cortana" community,
You can click/tap on Community Hub (shown at the top of every page) -> Browse All Community Hubs to view the full list of all product related Hubs.

Excel Community Hub:
https://techcommunity.microsoft.com/t5/excel/ct-p/Excel_Cat