Results 1 to 3 of 3

Thread: Footer Format

  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Las Vegas, Nevada, USA
    Thanked 0 Times in 0 Posts

    Footer Format

    I would like to change the default date format for Excel97 page footer. When I select the date icon the date is displayed as m/d/yy. I would like to change that to dd-mmm-yyyy. Where can I find the settings to make that change? Will this format be retained by the spreadsheet if another user with a different setting opens it?

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Kortrijk, Belgium
    Thanked 0 Times in 0 Posts

    Re: Footer Format

    There is no way to change the date format in the header or footer, as far as I know, but you can do it with a macro. e.g. you use the Workbook_BeforePrint event for this

    <pre>Private Sub Workbook_BeforePrint(Cancel As Boolean)
    Dim dDate As String
    dDate = Format(Now(), "dd/mmm/yyyy")
    With ActiveSheet.PageSetup
    .LeftFooter = dDate
    End With
    End Sub

  3. #3

    Re: Footer Format

    You will need to do this thru the Control Panel in Windows.
    - Click on Start, Settings, Control Panel
    - In the Control Panel folder, open Regional Settings.
    - In that dialog box, goto the Date tab
    - Change the Short Date Style to dd-mmm-yyyy (or whatever format you want)

    This will now set your system's short date display to what you want.
    However, if you don't wish to set ALL other apps / settings to this date style, then you'll have to use the macro.
    And new users will have to use this macro to set the footer.

    Also, the date display format for the footer will be based on the user's PC's settings described above.
    I think that problem can only be solved with the macro.
    (I could be mistaken though <img src=/S/shy.gif border=0 alt=shy width=15 height=15>)


Posting Permissions

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