How to have a long date in English US format on an Italian locale system?

%3CLINGO-SUB%20id%3D%22lingo-sub-2869064%22%20slang%3D%22en-US%22%3EHow%20to%20have%20a%20long%20date%20in%20English%20US%20format%20on%20an%20Italian%20locale%20system%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2869064%22%20slang%3D%22en-US%22%3E%3CP%3ELet%20us%20suppose%20that%20I%20have%20a%20date%20in%20an%20Excel%20cell.%20In%20my%20regional%20settings%20for%20Windows%2010%20I%20have%20set%20for%20my%20Region%20(Italy)%2C%20a%20short%20and%20long%20format.%20In%20fact%2C%20if%20I%20go%20to%20Number%20Formats%2C%20I%20can%20select%20both%20to%20format%20my%20cell.%20Now%2C%20let%20us%20suppose%20that%20in%20the%20same%20Excel%20sheet%20I%20have%20another%20date%20that%20should%20be%20formatted%20as%20short%20or%20long%20date%20in%20English%20US%20format.%20If%20I%20go%20to%20Number%20Formats%20and%20I%20select%20for%20that%20cell%20the%20English%20US%20locale%2C%20I%20see%20only%20Date%2C%20not%20Short%20or%20Long%20date.%20Of%20course%20I%20need%20to%20format%20THAT%20cell%2C%20not%20to%20change%20the%20locale%20of%20my%20whole%20operating%20system%20which%20would%20affect%20other%20applications%20too.%20Any%20idea%20how%20to%20do%20that%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2869064%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2869548%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20have%20a%20long%20date%20in%20English%20US%20format%20on%20an%20Italian%20locale%20system%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2869548%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1191926%22%20target%3D%22_blank%22%3E%40Dario_de_Judicibus%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20could%20apply%20the%20custom%20format%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%5B%24-en-US%5Ddddd%20mmmm%20d%2C%20yyyy%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eor%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%5B%24-en-US%5Dmmmm%20d%2C%20yyyy%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2876879%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20have%20a%20long%20date%20in%20English%20US%20format%20on%20an%20Italian%20locale%20system%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2876879%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1191926%22%20target%3D%22_blank%22%3E%40Dario_de_Judicibus%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20shall%20be%20a%20lot%20of%20options%20for%20each%20selected%20locale%2C%20do%20I%20understand%20correctly%20you%20don't%20see%20them%3F%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20541px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F319443iA1ACBE35E77C78D2%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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?

5 Replies

@Dario_de_Judicibus 

You could apply the custom format

 

[$-en-US]dddd mmmm d, yyyy

 

or

 

[$-en-US]mmmm d, yyyy

@Dario_de_Judicibus 

It shall be a lot of options for each selected locale, do I understand correctly you don't see them?

image.png

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.

@Dario_de_Judicibus 

My current locale is English UK, but if to select any other one, e.g. Italian, I see long date down to the list

image.png

Tha is NOT the long date: Long Date is "mercoledì, 14 marzo 2012".