Using dates with slashes, format mm/dd/yy, doesn't work

Question

I have just installed Office 2019 and when I try to handle dates I am not offered the mm/dd/yy format. I have tried different locales, but in all cases, the suggested formats all include hyphen and not slash. While I live in Canada, I have also tried United States formats. All show hyphens and none show slashes, contrary to any documentation I have seen.

I have existing sheets with that format and I do not want to convert everything over to a different, unnatural (for me) format. It is especially troubling when I try to update a sheet that was created in an earlier version.

See example:

Answer 1

In Windows, click the Start button and start typing set regional format.

You should soon see 'Set regional format' in the search results.

Click on it.

Does the 'Short date' format use - instead of / ?

If so, click 'Change data formats' and select a format using /

If that doesn't help:

You can force Excel to use / by clicking Custom in the Category list, and specify mm/dd/yyyy in the Type box.

Answer 2

Hi John

My name is David and I am an independent advisor and believe I can help with regards to your question.

In Excel you can create custom data formats for your file: https://support.office.com/en-gb/article/format....

See section: Create a custom date format.

You can use whatever separator you want either "-" or "/".

Please let me know if you have any queries or questions.

Kind Regards

Answer 3

Yes, the short date had hyphens and was easily changed to slash. Thank you very much.