+ Reply to Thread
Results 1 to 6 of 6

How do I format date field in footer?

  1. #1
    Terry Sharman
    Guest

    How do I format date field in footer?

    I'm pretty basic when it comes to Excel. How can I change the date format
    for the date field that I've placed in my footer? I would like it to show
    04-11-06.

    Thanks.

    Terry S.

  2. #2
    Forum Contributor
    Join Date
    08-28-2005
    Posts
    282

    how do I format date field in footer?

    hi!

    go to.. Format Cells > Custom > mm-dd-yy

    -via135



    Quote Originally Posted by Terry Sharman
    I'm pretty basic when it comes to Excel. How can I change the date format
    for the date field that I've placed in my footer? I would like it to show
    04-11-06.

    Thanks.

    Terry S.

  3. #3
    Terry Sharman
    Guest

    Re: How do I format date field in footer?

    Thanks for the quick response, but this is in the "footer" and it doesn't
    seem to work as you wrote....

    Terry S.

    "via135" wrote:

    >
    > hi!
    >
    > go to.. Format Cells > Custom > mm-dd-yy
    >
    > -via135
    >
    >
    >
    > Terry Sharman Wrote:
    > > I'm pretty basic when it comes to Excel. How can I change the date
    > > format
    > > for the date field that I've placed in my footer? I would like it to
    > > show
    > > 04-11-06.
    > >
    > > Thanks.
    > >
    > > Terry S.

    >
    >
    > --
    > via135
    > ------------------------------------------------------------------------
    > via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
    > View this thread: http://www.excelforum.com/showthread...hreadid=531990
    >
    >


  4. #4
    gls858
    Guest

    Re: How do I format date field in footer?

    Terry Sharman wrote:
    > I'm pretty basic when it comes to Excel. How can I change the date format
    > for the date field that I've placed in my footer? I would like it to show
    > 04-11-06.
    >
    > Thanks.
    >
    > Terry S.


    Go to file > page setup then select the header/footer tab.
    Click on the custom footer button select the icon
    that looks like a little calender. It should place
    a variable for date &[Date] in whatever section you
    have selected.

    gls858

  5. #5
    Terry Sharman
    Guest

    Re: How do I format date field in footer?

    Thanks gls858. I've done that but the format is "dd/mm/yy" and I would like
    it to be "dd-mm-yy".

    Terry S.

    "gls858" wrote:

    > Terry Sharman wrote:
    > > I'm pretty basic when it comes to Excel. How can I change the date format
    > > for the date field that I've placed in my footer? I would like it to show
    > > 04-11-06.
    > >
    > > Thanks.
    > >
    > > Terry S.

    >
    > Go to file > page setup then select the header/footer tab.
    > Click on the custom footer button select the icon
    > that looks like a little calender. It should place
    > a variable for date &[Date] in whatever section you
    > have selected.
    >
    > gls858
    >


  6. #6
    Gord Dibben
    Guest

    Re: How do I format date field in footer?

    Terry

    You can effect limited changes to Excel's footer/header date format by adjusting
    your short/long date format in Windows Regional and Language Settings.

    Start>Settings>Control Panel..........follow your nose.


    Gord Dibben MS Excel MVP

    On Wed, 12 Apr 2006 05:12:02 -0700, Terry Sharman
    <TerrySharman@discussions.microsoft.com> wrote:

    >Thanks gls858. I've done that but the format is "dd/mm/yy" and I would like
    >it to be "dd-mm-yy".
    >
    >Terry S.
    >
    >"gls858" wrote:
    >
    >> Terry Sharman wrote:
    >> > I'm pretty basic when it comes to Excel. How can I change the date format
    >> > for the date field that I've placed in my footer? I would like it to show
    >> > 04-11-06.
    >> >
    >> > Thanks.
    >> >
    >> > Terry S.

    >>
    >> Go to file > page setup then select the header/footer tab.
    >> Click on the custom footer button select the icon
    >> that looks like a little calender. It should place
    >> a variable for date &[Date] in whatever section you
    >> have selected.
    >>
    >> gls858
    >>



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1