Multi-Language Issue - TEXT function
I would strongly recommend getting Stphen Bullens Excel 200n VBA book, it
has an excellent chapter on International issues with Excel.
regards
Charles
"Johnny" wrote in message
oups.com...
Hi all,
I have a spreadsheet template that I use to create Excel workbooks
that are being used by French, Spanish, German, and English speakers
using those respective versions of Windows and MS Office. I make use
of the the =TEXT(<text,<format) function in several places in these
workbooks to manipulate dates. The <format argument takes entries
like "m", "dd", "yyyy", etc.
Of course, those arguments change in languages other then English. I
guess I could store multilanguage info on a hidden worksheet or as
constants in a module and look them up after checking the language
version, but this is obviously a workaround.
Can anyone direct me to a good discussion of multilanguage issues in
Excel? I'm aware of this TEXT function "trap for the unwary", but I
wonder what else I'm missing!!!! I don't have machines with these
various languages installed to run tests.
Thanks,
Johnny
|