Thread: Date bug
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] pfsardella@yahoo.com is offline
external usenet poster
 
Posts: 96
Default Date bug

?Format(Date$, "dd, mmm, yyyy")
11, Jul, 2003

Using Excel 97SR2 on Windows 98SE, I tried your expression in the
Immediate window, and received the correct date.

Maybe the regional settings (set through Control Panel) are different
on my computer.

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
On Fri, 11 Jul 2003 07:56:18 -0700, "Mike Berry"
wrote:

Format(Date$, "dd, mmm, yyyy")