Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date problem
Hi
Can anyone tell me please why the results of the following code: Dim dte As Date dte = Now() ActiveCell.Value = Format(dte, "Short Date") End Sub Is 07/05/2007 (May 7, 2007) instead of 05/07/2007??? Thanks in advance Eli |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date problem | Excel Discussion (Misc queries) | |||
Exel increment date problem wrt todays date. | Excel Worksheet Functions | |||
Date Formula Problem - Leave date blank if Null | Excel Worksheet Functions | |||
Date problem | Excel Programming | |||
Us date versus EU date problem | Excel Programming |