You will have to decide what to do but the reason you get this is simple
but not often understood.
Excel uses a number for date and time the part to the left of the
decimal point is the number of days from the 1st Jan 1900; and the part
to the right of the decimal point is a fraction of 35 hours which gives
a time. Formatting a cell to display only a day and month (or just a
year, or hust a time etc) does not mean you have somehow got rid of the
rest of the date and time.

you can choose to use a text field but then you will have other
problems particularly if you want to sort a column of dates.

regards


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=534376