Conventional data format "dd/mm/yyyy" is absent and existing dates are replaced by "dd mm yyyy"

%3CLINGO-SUB%20id%3D%22lingo-sub-2267053%22%20slang%3D%22en-US%22%3EConventional%20data%20format%20%22dd%2Fmm%2Fyyyy%22%20is%20absent%20and%20existing%20dates%20are%20replaced%20by%20%22dd%20mm%20yyyy%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2267053%22%20slang%3D%22en-US%22%3E%3CP%3EWindows%2010%20Pro%3C%2FP%3E%3CP%3EOffice%20365%3C%2FP%3E%3CP%3EHP%20246-G7%20(9MW01LA%23AC4)%3C%2FP%3E%3CP%3EProblem%3A%26nbsp%3B%20the%26nbsp%3Busual%20data%20format%20%22dd%2Fmm%2Fyyyy%22%20is%20absent%20and%20existing%20dates%20are%20replaced%20by%20%22dd%20mm%20yyyy%22.%20How%20do%20I%20create%2Fimport%2Fset%20the%20conventional%20format%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2267053%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Windows 10 Pro

Office 365

HP 246-G7 (9MW01LA#AC4)

Problem:  the usual data format "dd/mm/yyyy" is absent and existing dates are replaced by "dd mm yyyy". How do I create/import/set the conventional format?

2 Replies

@xfischer1265 

Excel uses the date format set in Windows, in Start > Settings > Region or Control Panel > Region. Has dd mm yyyy been specified there?

Anyway, you can always select Custom in the Number tab of the Format Cells dialog, and enter dd/mm/yyyy in the Type box.

 

S0284.png