Excel Default Dates

%3CLINGO-SUB%20id%3D%22lingo-sub-2302271%22%20slang%3D%22en-US%22%3EExcel%20Default%20Dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2302271%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20text%20field%20in%20a%20spreadsheets%20into%20which%20I%20enter%20comments.%20I%20prefix%20each%20comment%20with%20the%20date%20by%20pressing%20'Ctrl%2B%3B'%3B%20this%20provides%20the%20date%20in%20the%20format%20dd%2Fmm%2Fyyyy.%20For%20space%20reasons%2C%20I%20would%20like%20this%20to%20be%20dd%2Fmm%2Fyy%20but%20cannot%20find%20a%20way%20to%20change%20the%20default%20setting.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20changed%20the%20short-date%20format%20in%20the%20Windows%20local%20settings%20(as%20suggested%20elsewhere)%20but%20this%20has%20no%20effect%20within%20Excel.%20I%20cannot%20format%20the%20column%20as%20a%20date%20fields%20as%20I%20include%20text%20comments%20also.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyone%20got%20any%20thoughts%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2302271%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2302355%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Default%20Dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2302355%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1039558%22%20target%3D%22_blank%22%3E%40NickCurties%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENot%20sure%20that%20could%20be%20changed%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fbettersolutions.com%2Fexcel%2Fdates-times%2Fshortcut-keys.htm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EExcel%20Dates%20%26amp%3B%20Times%20-%20Shortcut%20Keys%20(bettersolutions.com)%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a text field in a spreadsheets into which I enter comments. I prefix each comment with the date by pressing 'Ctrl+;'; this provides the date in the format dd/mm/yyyy. For space reasons, I would like this to be dd/mm/yy but cannot find a way to change the default setting. 

 

I have changed the short-date format in the Windows local settings (as suggested elsewhere) but this has no effect within Excel. I cannot format the column as a date fields as I include text comments also.

 

Anyone got any thoughts?

 

2 Replies

@Sergei Baklan 

Thanks Sergei. It looks like I will have to work with the full year if I want to use the shortcut.