Forum Discussion
How to have a long date in English US format on an Italian locale system?
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?
You could apply the custom format
[$-en-US]dddd mmmm d, yyyy
or
[$-en-US]mmmm d, yyyy
It shall be a lot of options for each selected locale, do I understand correctly you don't see them?
- The problem is that the LONG DATE Format exist ONLY for CURRENT locale in Windows. So if my locale is Italian, I have short and long date formats ONLY for Italian, not for English. Of course, Windows changing regional settings is NOT a solution because it would affect any other application. The only solution is to use [$-en-US] before format specification.
My current locale is English UK, but if to select any other one, e.g. Italian, I see long date down to the list
