Oct 21 2021 05:25 AM
Let us suppose that I have a date in an Excel cell. In my regional settings for Windows 10 I have set for my Region (Italy), a short and long format. In fact, if I go to Number Formats, I can select both to format my cell. Now, let us suppose that in the same Excel sheet I have another date that should be formatted as short or long date in English US format. If I go to Number Formats and I select for that cell the English US locale, I see only Date, not Short or Long date. Of course I need to format THAT cell, not to change the locale of my whole operating system which would affect other applications too. Any idea how to do that?
Oct 21 2021 07:15 AM
You could apply the custom format
[$-en-US]dddd mmmm d, yyyy
or
[$-en-US]mmmm d, yyyy
Oct 23 2021 04:12 AM
It shall be a lot of options for each selected locale, do I understand correctly you don't see them?
Oct 25 2021 05:40 AM
Oct 25 2021 07:00 AM
My current locale is English UK, but if to select any other one, e.g. Italian, I see long date down to the list
Oct 25 2021 10:25 AM