Formatting date question ....

[sobeitjedi]

I have data in columns G & H which is 13/11/2019 (ie, 13th November 2019)

I want this date to display as 2019/11/13

When I formal cells > custom and enter the format as yyyy/mm/dd, this looks good. I save (as csv) and reopen the file, but it reverts back to it's original formatting? How do I resolve?

 

[sobeitjedi]

Ah, got it now, thank you for clarifying. Never even knew the option was there.

Still issues with the data though .... I go through the wizard, highlight the date columns as YMD (see image https://photos.app.goo.gl/pjFQhdCZePieEkSr5) but when imported it's still displaying in the traditional view (https://photos.app.goo.gl/ijmLxorjkcUai2bW8)

 

[Fluff]

That I don't understand, it should keep the dates in the YMD format. As I've never had any problems using it before, I'm not sure what to suggest.

 

[ClaireS]

You probably need to enable the Legacy Wizards first: go to File, Options, Data and tick "From Text (Legacy)".