regional settings

  1. G

    Text Function in Excel do not recognize YYYY as Date

    Hello All, I have a problem with my Text function in excel. When I type Text(02/12/2014,"ddmmyyyy") the function show me 1202yyyy. I know that there are other posts about this problem here and on google, however none of them seem to solve my problem. Solutions that I already tried: When I...
  2. G

    Extremely slow spreadsheet with certain Windows Regional Settings

    Reporting very unusual problem with an Excel spreadsheet. The spreadsheet loading time & flicking through values within the drop down menus varies considerably depending on the Windows Regional Settings. I need to solve this ‘performance problem’ asap, but cannot find any logical explanation or...
  3. A

    How do I know the language my system is using?

    Hello guys, I am writting a code for which I use numbers with decimal and thousand separators. I am facing a problem on the comma Vs dot criteria for different regional settings. If I could use the system language as a variable this problem would be solved as I could manipulate the user input...
  4. S

    Regional settings causing formulas not to work

    Hi everybody, Recently I have noticed that there are problems in my formulas related to the regional settings of my operating system. I am working with English (US) format but my colleagues are working with German(Germany) format. The difference between German and English is that "," and "."...
  5. M

    concatenate number and text and keep formatting (regional compliant) without vba

    I am using a custom app to export data from asp.net/silverlight to excel using an xslt mapping - the requirement is that the dates and numbers must be formatted to the client's regional settings. This works great! Except that I have a need to concatenate 2 hidden fields into one visible field...
  6. Z

    Regional settings

    I have got a problem that has given me a really hard time for many months. I'm using the formula '=Text(Today(),"[$-409]mmmm-aa")' to retrieve today's date as a string, expressing the whole month and a two-digit number in English. If you see I'm using "aa" since in my regional language "aa" is...
  7. A

    Excel Date Formatting VS Regional Settings

    I have a problem where I am creating excel file with date format of "mm/dd/yyyy" and my machine's regional settings are English (US). Now when my end user downloads my excel (who has English (Canada)) they see the excel file with no issues except the date's messed up due to their regional...
  8. M

    Ctrl-Shift-3 to short date format

    Hi I don't tend to post to forums since the oracle (Google) tends to answer most of my questions, but this one I have been wondering about for some years. I love shortcut keys and hate the mouse. I therefore managed to configure my Excel such that I can do pretty much anything with the keyboard...
  9. F

    Issue with VBA / max and eomonth functions

    Hello I have been writing a piece of code that (among other things) calculates the last day of the prior month, given as input the date for tomorrow. As a background, I am using Excel 2003 SP3 (English language version), and my regional settings in Windows are Finnish, i.e. the standard date...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top