Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Formats
i am having a bit of a problem with date format
manipulation. I capture a date from a text box on a form and write it to a cell on a worksheet, in the process the date switches from UK (dd/mm/yy) to US (mm/dd/yy) format, despite the fact that it appears on the form in the UK style and the cell in the worksheet has the UK date format set. Any advice? This is the code fragment if it is on any use: A) tmpStr = Form1.Textbox1.text B) Selection.Formula = tmpstr Fragment (A) is in one procedure fragment (B) is in another, no other manipulation takes place. I have even tried using Format(tmpstr, "dd/mm/yy") Murray |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Formats | Excel Discussion (Misc queries) | |||
Date Formats | Excel Discussion (Misc queries) | |||
Date Formats | Excel Discussion (Misc queries) | |||
Date formats | Excel Discussion (Misc queries) | |||
Date Formats | Excel Discussion (Misc queries) |