ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I change the date in the 2005 attendance calendar to 2006 . (https://www.excelbanter.com/excel-discussion-misc-queries/101147-how-do-i-change-date-2005-attendance-calendar-2006-a.html)

Ference

How do I change the date in the 2005 attendance calendar to 2006 .
 

--
Ference

MattShoreson

How do I change the date in the 2005 attendance calendar to 2006 .
 

overwrite the number in the cell?


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=564684


Bob Phillips

How do I change the date in the 2005 attendance calendar to 2006 .
 
Type in 2006?

"Ference" wrote in message
...

--
Ference




MattShoreson

How do I change the date in the 2005 attendance calendar to 2006 .
 

buy a new one?


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=564684


Ference

How do I change the date in the 2005 attendance calendar to 20
 
I was looking for the "magic cell" that would then change all of the months
to the correct format. I guess you are telling me to put in my own formulas
- ?
--
Ference


"Bob Phillips" wrote:

Type in 2006?

"Ference" wrote in message
...

--
Ference





Gord Dibben

How do I change the date in the 2005 attendance calendar to 20
 
Ference

Post the URL to the Calendar Template.

I will have a look at it.

Must be a simple method.


Gord Dibben MS Excel MVP

On Wed, 26 Jul 2006 09:04:02 -0700, Ference
wrote:

I was looking for the "magic cell" that would then change all of the months
to the correct format. I guess you are telling me to put in my own formulas
- ?




All times are GMT +1. The time now is 11:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com