Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Desperation is Setting in - Date Formats! :-(
I have a series of UserForms capturing and writing data to an worksheet,
trouble is no matter how I format anything cannot get the format of a date entered in the UserForm to match the worksheet formats. ie When I enter 05/02/06 (5th Feb 06)on the UserForm it is transposed to 02/05/06 (2nd May 06) on the worksheet! Am I going nuts or is there a way to get around this - it's seriously knocking my plug in now! -- Zani (if I have posted here, I really am stuck!) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting default formats | Excel Discussion (Misc queries) | |||
GETPIVOTDATA....Excel 2000....Desperation! | Excel Worksheet Functions | |||
Setting up templates with formats | Excel Discussion (Misc queries) | |||
VBA Setting .Value to a date does not respect local system setting | Excel Programming | |||
Index / Match - desperation | Excel Programming |