Thread: Entering Dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kmkx70a kmkx70a is offline
external usenet poster
 
Posts: 1
Default Entering Dates

I would like to enter dates with just the month and day. When I do, Excel
automatically enters the year also. this really messes up sorting. I want to
enter the date with out the year showing up. I format the cells with mmm/dd
but that doesn't help.
Any help would be appreciated. Harry