language

Hi guys, I'm importing text data separated with ";" . The numbers decimal sign is "," in the CSV, so 14,000 = 14 I have 2 file if im import (drag and drop) into first its works like charm, if i drop into other its give wrong numbers 14,000 = 14000. Does anyone know any solution? The first...

Hi All I developped a little program to learn vocabulary (German to French and vice versa) I use also the SAY IT function which says the words. I work with an English Excel 2013 Version therefore SAY IT pronounce all German or French word with an English accent, which is of course useless. How...

Hi all, I'm trying to create a dynamic tool that references end user input in the query and performs operations on the source data. Right now I have a table on a spread sheet where a user can provide input which is then called in the query to create a custom column. The inputs correspond to...

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...

Hello, I am stuck in a jam, being an Excel novice! I have a form (in excel format) complete with drop downs. I need to be able to add a drop down, that lets users select between different languages. The entire spreadsheet (including the values within the drop downs) needs to change to reflect...

Does anyone know a good resource for learning the language used in Visual Basic on Excel? I know it's a loaded question since it's a variation of computer programming language - but I am looking for a solid introduction so I can know what I am doing with commands in VBA rather than just...

Does anyone know what language the production simulation program, Witness (by Lanner group), uses? And where I could get some help learning it. I think it's similar to <ACRONYM title="visual basic for applications">VBA</ACRONYM> but its not exactly the same and Witness doesnt give you any hints.

Hi, I'm running Excel 2010 English on a Windows 7 - Swedish (not English). In Excel I have created a sheet full of calculations using the TEXT() function. Suddenly (perhaps due to Win7 upgrade) my Excel doesnt understand =TEXT(A1;"yyyy") anymore, it wants the date format in Swedish codes...

Hello, I have a user who may find my workbook easier to use if it is in his home language. Is it possible to have a macro button that can switch the language of the page and/or the sheet into my specified language (in this case Chinese)? Also I have a number of other macro buttons with text on...

Hello, I am attempting to install the analysis toolpak for Excel 2007, and when I do so it shows up in the ribbon in French, and all of the language used within it is in French. Does anyone know of a solution to this? Thanks

Hello, Normally I work with Excel in Spanish, since most of our PCs have Office in Spanish, however people that don't usually experience difficulties in several formulas like the "=text()" formula. For example, I'm using this formula to convert a date to text with the following format: "full...

Hi, I have a problem with text data in Hebrew that has been written wrongly, from left to right. As you may know, Hebrew words are to be written and read from right to left. Let me give you an example, but in English. I have English text, but it is written in each cell from right to left...

I am using Excel 2007, with Windows Vista home premium 32bit, When I go to Excel Options>proofing>autocorrect options, the title bar shows "AutoCorrect:English (united Kingdom)" I need it to be set to "English (United States)" is there a way to change this setting? Thank you In advance.

"Huh?! Chinese?! I don't even speak Chinese!!! Well, we'll just pop into the old regional settings and get this taken care of!" And thus began a rather frustrating quick and dirty scouring of the internet. I had just bought a new notebook and was running Vista. I'd hopped into Excel for the...