Rocky Smolin
rockysmolin at bchacc.com
Fri Sep 21 07:29:24 CDT 2012
I don't know but does this help? http://support.microsoft.com/kb/94870 Rocky -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Kathryn Bassett Sent: Thursday, September 20, 2012 10:46 PM To: dba-tech at databaseadvisors.com Subject: [dba-Tech] Excel 2010 header question In a cell, you can choose the properties of the way the &[date] shows up. In the header I can't find a way to do that. It shows up as 20 09 2012. I want it to show up as 20 Sep 2012. I'd even settle for Sep 20, 2012. Both the long date and short date in the operating system are set to show as 20 Sep 2012. In Quattro Pro I can set headers to the format I want. What the heck is the code to make the current date show the way I want? -- Kathryn Rhinehart Bassett (Pasadena CA) "Genealogy is my bag" "GH is my soap" kathryn at bassett.net http://bassett.net _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com