Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multi-Language Issue - TEXT function
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi-column sort issue in Pivot Table | Excel Discussion (Misc queries) | |||
Multi column sort issue within Pivot table | Excel Discussion (Misc queries) | |||
List Box - Multi Select Issue | Excel Worksheet Functions | |||
Add-in function - language | Excel Worksheet Functions | |||
Date function/Text issue | Excel Worksheet Functions |