Hi Guys,

I used to be able to format a date in excel as dd/mm/yyyy
or yyyy/mm/dd

Now since excel 2016, I get an error that says
"Excel cannot use the number format you typed.
Try using one of the built-in number formats"

How do I get around this, the default dates in excel are useless
thanks!