how can I stop Excel Advancing the year by 1 when I enter a date?
Hi Priscilla:
Both Ron and Peo have indicated the correct method of entering dates.
However if you have already entered dates using the single quote you can
convert them with:
=DATE(2000+RIGHT(A1,2),--LEFT(A1,2),1)
--
Gary's Student
"Priscilla" wrote:
I did something which caused a problem with entering dates in Excel. When I
enter a date, it looks fine until I leave the cell. Then the year advances by
one. For example if I type in 05/05, when I tab out the cell displays May-06.
I have tried right clicking on the cell and selecting the mmmyy selection,
but it makes no difference. I also selecting from tried the format dropdown
menu. Nothing changed it. the only way I could enter a date and have it stay
as entered was to put a quote mark before the numbers. what did I do to cause
this problem and how can i fix it?
|