I hadn't seen that keyboard shortcut before.
I see what you mean, but the way I fixed this was to format the cell, (or perhaps the whole column), to a Custom format. What I found then was that, although the date appeared as 02/03/2009 when I pressed CTRL + ; when I then pressed Enter or highlighted any other cell to fix the value in the cell, it changed the format to 02-Mar-09.
You need to scroll down in Custom format options until you see the dates, then it will show as dd-mmm-yy.
Does that help?
OS is MS Windows XP Home SP2
With MS Excel 2003 , to insert the current date, I press Ctrl+;. In my case it comes up as 02-03-2009.
I would like it to appear as 02-Mar-2009, or 02-Mar-09, as set at the Regional & Language differences at the Control Panel for "Date". Even when I format the cell for the date to appear as 02 Mar-09, it still appaers as 02-03-009. So, what do I do to insert the current date to appear as 02-Mar-2009 ? I do want the date to change for which I can use the date function =Today() . Thanks.