Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change year in downloaded calender template
I downloaded a weekly time sheet with breaks and tried to change the week starting and ending dates from 05 to 09 but it prints 10/17/09 as a Friday instead of a Saturday. Why is the answer not searchable? Am I the only one w this dumb question about excel03? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change year in downloaded calender template
Format (just temporarily) those date cells in an unambiguous format:
mmmm dd, yyyy dddd And you'll see that 10/17/09 isn't October 17, 2009 ======= ps. I'd use windows control panel to change the short date format to mm/dd/yyyy (a 4 digit year). Then back to excel and change 2005 to 2009. I like the 4 digit year, but if you don't like it, remember to change the windows short data back to what you like. gmatt wrote: I downloaded a weekly time sheet with breaks and tried to change the week starting and ending dates from 05 to 09 but it prints 10/17/09 as a Friday instead of a Saturday. Why is the answer not searchable? Am I the only one w this dumb question about excel03? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I downloaded a template but the font is white and I can't change i | Excel Discussion (Misc queries) | |||
I downloaded a template but the font is white and I can't change i | Excel Discussion (Misc queries) | |||
change the year in a calendar template to different year | Excel Discussion (Misc queries) | |||
one year calender | Excel Discussion (Misc queries) | |||
Annual leave calender year 2006 - template | Excel Discussion (Misc queries) |