Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using the Excel TEXT function within a VBA program
Despite the fact that I am using a French version of Excel
2000, the Excel "Text" function, expects its format parameters in English and returns a result in English when used within a VBA 6 instruction. This is frustrating when dealing with month or day names. For instance, an instruction such as : Application.Text(38000,"mmmm aaaa") returns "january aaaa" instead of "janvier 2004". I have checked the "International" properties of the Application. They seem to be set properly : Daycode is set to "j" (stands for "jour" or day in French) Yearcode is set to "a" (stands for "année" or year in French) Thank 's for help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene | Excel Discussion (Misc queries) | |||
The 'DATEDIF' Function is not listed on my Excel program. | Excel Worksheet Functions | |||
merging excel program with tdc finance program | Excel Programming | |||
program a function key | Excel Programming | |||
When I Import an Access Table With an Excel Function in a Cell it Displays as Text not as a Function in Excel | Excel Programming |