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

Copper 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