locale

I have a workbook that is shared amongst colleagues in different countries on MS Teams. When the workbook is opened in Poland the cell shows #ARG! error, while it shows #VALUE! error in the UK. Evaluating the formula results in an error, but if I edit the formula and press enter it shows ok...

Hello! I would like to modify CELL function that is using info_type argument to work independently of Excel or Windows locale settings. The problem is that I am using Excel with SK locale setting: CELL("adresa"; ...) which will not work when opened in Excel using other locale settings, e.g...

The Format Cells "Date" settings are behaving... strangely. I regularly pull in data from a reporting system via csv files. The source formatting is always the same, but Excel seems to be seeing something that I am not. When I copy the csv data from the source file to the .xlsx spreadsheet, I...

Hi, I used Adobe Acrobat to convert PDF files to Excel files. When I open the file it looks good, including the column of dates. However, when I sorted by date I get a mess. It turns out that many, but not all, of the the dates are in Afrikaans. So although the cell displays 04/12/15 (April...

Occasionally in Excel 2010 when I open Format Cells, I am presented with an odd result. Does anyone have a good explanation? Is my Lenovo keyboard doing this?

I have an end user in Korea who is encountering an error when they execute a ListObject.QueryTable.Refresh from Excel VBA against an Access Db Query. There are three Excel worksheets with ListObject.QueryTable.Refresh updates in the workbook. Two are linked to Access Queries and one is linked to...