Not really. Assuming that your data is contiguous, you could just enter all
your data as 2008, then go back and do a REPLACE of 2008 with the correct
year for that particular data.
--
John C


"sopranoiam" wrote:

I have a huge spreadsheet that I am typing dates into from past years. Is
there an easy way to tell certain cells that they are 2003 or 2004 so when
for example I tell the cell 2/11, it won't pop up 2/11/08 automatically it
will pop up 2/11/03 instead? I have to change year dates about 3-5 times
during this and there are probably 2000 entries I need to make before the day
is through and an easy formula would sure help, can anyone suggestion
something to get me started?