4 ms·
This is the bane of my existence when working with Excel. I'm spending too much time figuring out that "RAND" (which is what you'd find in search) is "ZUFALLSZA
by probably_wrong 7y ago
This is the bane of my existence when working with Excel. I'm spending too much time figuring out that "RAND" (which is what you'd find in search) is "ZUFALLSZAHL" in German Excel (which I use at work) and "ALEATORIO" in Spanish (which I use at home).
- rovr138 7y agoIs this on VBA or for formulas too?
- jaclaz 7y agoIt is for spreadsheet functions, VBA is English only, but there are anyway some quirks, as an example inside VBA the decimal point (separator) is actually a point whilst /as an example in Italian) the decimal separator is a comma, and this creates often the need to convert back and forth the numbers.
- jaclaz 7y agoJFYI, what I often do for those functions I am not already familiar with both in Italian and English (it doesn't work for really all functions) is to use the English original I find in (the English version of) Spread32 (an extremely small Excel compatible program): http://www.byedesign.co.uk/ http://www.byedesign.co.uk/ then save the worksheet and re-open it with the Italian Excel, since the functions are actually saved internally as an "ordinal" (or whatever) and interpreted by Excel in its "local" language.