Forum Discussion
Conventional data format "dd/mm/yyyy" is absent and existing dates are replaced by "dd mm yyyy"
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 conventiona...
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.
Problem solved. Thanks.