Date formatting in footer

  • Thread starter Thread starter computerguy
  • Start date Start date
C

computerguy

How do I change the format of the date option in the footer of a worksheet?
For example, currently it shows 8/9/06; how would I change it to Aug 8, 2006
or 9 Aug 2006 for example?.

TIA
 
You can make some changes in Windows Regional Settings to your short date format
which is what Excel uses for the footer date.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Query 9
insert a line 1
Formula to fill cells based on Date of Arrival and Date of Departure 1
date format convert 2
Comparison bar graphs 2
Formatting Footers 5
Custom footer date format 2
Date Format 1

Back
Top