Excel keeps changing operators in multilingual sheet (Farsi for texts and English for numbers). For example when I try to type in "52.1429" it changes "." to a "/" and the number becomes a division "52/1429" so number "0.04" fills the cell. Or... Lets assume I want to fill H3 cell with product of H1 and H2 multiplication. when I write "=H1*H2" in H3 Formula Bar, excel rejects the operation and fills the cell with "#VALUE!" and the error message is this: "A value used in the formula is of the wrong data type."
For the problem with decimal numbers I tried copy-pasting the number from places that I think they are in English for sure (like browser address bar or a plain text editor); Or using alphanumeric section of keyboard instead of using the numpad. In both situations I believe the final number is treated as text/string data. Or even assuming the "/" character that excel uses looks like a Slash but actually is not a slash I tried to editing the decimal number in H3 cell. I changed the whole number part to 52 and without touching the character in decimal point position I changed the fractional part to 1429. Again after pressing the Enter key the result is 0.04 (0/0363890832750175 unformatted, the same number I just edited)!
For my problem with formula part I tried to use "=PRODUCT(H1,H2)" in H3 cell. This time an error message pops-up with this sentence in the first row: "There's a problem with this formula. Also while typing the template that pops up in tool-tip is: "PRODUCT(number1;[number2];...)". Filling the formula with this format "=PRODUCT(H1;H2)" results in 0 and the Latin semicolon in formula turns into a Persian semicolon "؛".
Any thoughts?
