Excel 97 Date format

[Jegacats]

This has been an ongoing problem

I would like for the date to take the format
international yyyy,MM,dd
No matter what regional settings I give, it just won't .

What am I missing.

 

[Von Pookie]

Well, you could just select the cells that have the date and instead of formatting it as date, select "custom" from the list and enter yyyy/mm/dd.

I don't think there's a way to set it to automatically format that way for default, unless someone's got a macro somewhere.

Hope it helps,

 

[Jegacats]

Thanks, it does help. You confirmed what I
suspected.