[dba-Tech] Excel 2010 header question

Kathryn Bassett kathryn at bassett.net
Fri Sep 21 00:46:09 CDT 2012


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   






More information about the dba-Tech mailing list