regional

Dear all, I have made a vba macro code to get date from Excel cells in a special format to be used for follow up. ActiveCell.FormulaR1C1 = "=TEXT(RC[1],""ÅÅÅÅ-MM-DD"")" ActiveCell.FormulaR1C1 = "=TEXT(RC[1],""YYYY-MM-DD"")" In Sweden, Windows regional date format is ÅÅÅÅ-MM-DD. The letter Å...

Is it possible to change the regional settings in windows to Australian with a macro? I need to know as I can build that into my spreadsheet as the users might not know how to change it manually.

Hi guys, I have a file that is shared with several people. Some of them have Spanish regional settings, and some of them English (I don't think there's anything else than those two). The thing is that the file has a date column, and I have a format "mm - aaaa" which for those who have it in...

Hi, i need the code for changing regional settings in windows environment: 1. Check what regional settings are used 2. If RS are Windows default (in my case polish -pl) - change to US (United States) 3. If US - change to windows defaults. Cross posted here...

I'm creating a file that will be sent out to regional offices around the world. We've created a tool that automatically copies pertinent data to a Powerpoint presentation to submit to the corporate office, but I've noticed that all number formats remain in the local currency or date format...

Hello, I have a spreadsheet that I developed on a Windows 7 computer, with an English OS and Swiss German keyboard. Regional settings are for Swiss German keyboard and number format. This file is shared amongst a large group of people around the world. In it, there is a range with a simple...

Good Morning, I'm facing an annoying issue, in my data sheet dates are formatted dd.mm.yyyy and when I create my pivot, data are read mm.dd.yyyy which makes the automatic grouping by month totally wrong. I have checked my regional settings and everything is in dd.mm.yyyy. Any idea where to...

Hi I am making a spreadsheet form for some of our guys to use. This spreadsheet will be used on numerous computers with different regional formats. I am trying to make the data entry into some cells be "dd/mm/yy hh:mm" and it will display "dd/mmm/yy hh:mm". This works fine if the computer's...