Using a date with 30 in the year

%3CLINGO-SUB%20id%3D%22lingo-sub-1707327%22%20slang%3D%22en-US%22%3EUsing%20a%20date%20with%2030%20in%20the%20year%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1707327%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20dates%20in%20excel%20out%20into%202030%20and%20when%20you%20type%2005%2F01%2F30%20it%20writes%20the%20date%20as%2005%2F01%2F1930.%26nbsp%3B%20Does%20anyone%20know%20of%20a%20fix%20instead%20of%20writing%20it%20in%20its%20long%20form%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EJ%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

1 Reply
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