L
LKovathana
I have a spreadsheet that needs to be sent out to several
countries. In testing the sheet (by changing Regional
Options settings), I find that not all of the formatting
translates very well.
For example, menu \Format\Cell as custom format DD.MM.YYYY
works fine, but if you use that value in a formula, you
have to translate it back to text. In the US that would
be Text(ref, "DD.MM.YYYY"). However, in Germany, it
is "TT.MM.JJJJ". I also find that in diagnostic messages,
in which I am converting numbers to text, "0,000" does not
yield the expected result. In Germany, thousands are
formatted with a "." and the decimal is a ",". It goes on.
Does anyone have best practices with respect to
regionalizing a spreadsheet?
Thanks much.
countries. In testing the sheet (by changing Regional
Options settings), I find that not all of the formatting
translates very well.
For example, menu \Format\Cell as custom format DD.MM.YYYY
works fine, but if you use that value in a formula, you
have to translate it back to text. In the US that would
be Text(ref, "DD.MM.YYYY"). However, in Germany, it
is "TT.MM.JJJJ". I also find that in diagnostic messages,
in which I am converting numbers to text, "0,000" does not
yield the expected result. In Germany, thousands are
formatted with a "." and the decimal is a ",". It goes on.
Does anyone have best practices with respect to
regionalizing a spreadsheet?
Thanks much.