| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find out country-dependent Format Codes
Hi
I fill cells with date-values via OLE from non office/VB application. If I submit a number and set the NumberFormat of the cell to 'mm/dd/yyyy', it is correctly interpreted...for an english installation. Problem: Switching to a german installation for example will not work. This is because the Format Codes are not understood by Excel. In Germany it is required to format the year as 'JJJJ' and not 'yyyy'. I want to build an international application, which automatically chooses the right characters Could anyone tell me, how I can detect the language/country/locale dependent valid format codes for year, day etc. ? Is it an excel property, or do I have to look in the registry Please help Dirk |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find dependent files | Excel Discussion (Misc queries) | |||
| typing 'Up Country' ends up as Up Country' ? | Excel Discussion (Misc queries) | |||
| How can I find the alpha numeric codes in excel please,Thank you. | Excel Discussion (Misc queries) | |||
| Format the Cell into a telephone number but using country code | Excel Discussion (Misc queries) | |||
| find top 25 codes | Excel Worksheet Functions | |||
Threaded Mode
