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 conventional format?
2 Replies
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.
