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.
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.
hi!
go to.. Format Cells > Custom > mm-dd-yy
-via135
Originally Posted by Terry Sharman
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
>
>
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
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
>
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
<[email protected]> 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
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks