| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to over write Windows Date format?
Hi guys,
i had written a macro to get a date value and convert it to the date format which i need using the below code. date = Format(tempworksheet.Cells(1, 1).Value, "yyyy-mmm-dd"). it is getting converted fine when the regional language is US(English).When i change the language to czech it is not getting converted fine.The month is taken as date and date as month i.e if i enter 06/05/2007 when in US gives 05-JUN-2007 but when in czech gives 06-MAY-2007 also i am not getting the MAY in english it is coming in czech. I would like to know if there is some code to override windows settings.Please help me by repling fast. Regards, Arun |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Windows - Delayed Write Failed | Excel Discussion (Misc queries) | |||
| How do I write formula to conditional format using =if(and(or) | Excel Worksheet Functions | |||
| How can you format so you could write x squared using exponents? | Excel Discussion (Misc queries) | |||
| how do I write the date in an if statement | Excel Worksheet Functions | |||
| How to write a "Text" or date custom format | Excel Worksheet Functions | |||
Threaded Mode
