Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Sep 2002
    Location
    Green Bay, Wisconsin, USA
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formatting the date in a footer (Excel 2003)

    I use the "insert date" tool to insert a date in a footer, but I want to change the date format, for example, from 9/19/05 to 19 Sep 05 or September, 19, 2005. It there a way to do it?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formatting the date in a footer (Excel 2003)

    See <post#=458501>post 458501</post#>. The code posted by Steve must be inserted in the ThisWorkbook module. User CenterFooter (or LeftFooter or RightFooter) instead of CenterHeader.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •