If it's a date, it has 3 parts: month, day, and year. And if you intend to do
date arithmetic on thse numbers, you must enter them as dates. Excel will add
the year for you when you enter just the month and day.

You can format the cell with the custom number format "m/y".


On Sat, 5 Mar 2005 14:09:02 -0800, Barb L <Barb
wrote:

How do I put in the date without the year automatically a part of it? I
want just 12/4 and no year in a box on my data sheet because I want the
column to be short.