Making english language default

[deciog]

vletm

To conclude, there is more string from [$ -801] to [$ -999]
And I'm showing for future member studies

Hugs
Decio

 

[Peter Bartholomew]

Some more information is available from

[MS-LCID]: Appendix A: Product Behavior

The information in this specification is applicable to the following Microsoft products or supplemental software. References to product versions

msdn.microsoft.com

In her blog Mynda Treacy stated that in Excel 2016 you can either use the Language tags, or the 4 digit Language ID.
Perhaps there is some version dependence when it comes to which codes are supported?

 

[deciog]

Peter, good morning.

Fantastic

I was looking for this information a lot, I'm grateful for the tips this will help a lot

Another way that I'm looking for and I haven't found it yet, if it's more like this
for custom formatting like this [$ -x-systime]

I appreciate your help

A big hug

Decio Gassi

 

[Peter Bartholomew]

Hi Decio
Both [$ -x-systime] and [$ -x-sysdate] work in the TEXT() function, turning
43786.5
into
17 November 2019 and 12:00:00
respectively. I assume the date will show differently on your computer?
Peter

 

[Tom22]

The attached workbook explores Excel formatting to switch between languages.
The validation lists are date-values with explicit language settings.
The table headings are also date-values but conditionally formatted, as is the user input cell.

The key is the use of the last day of the month irrespective of language so the searches on number are independent of language settings. It may be that a correctly set up workbook would respond to the Windows localisation and this user interaction is unnecessary. I have no way of testing that however.

That has work Peter......thanks for the suggestion...Cheers