Thread: In Excel, is there a way to enter dates in mm/yyyy format?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marshaann_82
 
Posts: n/a
Default In Excel, is there a way to enter dates in mm/yyyy format?
What I need is for the cell to remember the date as mm/yyyy. when I format
the cell to display this, it still puts the day in there even though it is
not displayed. I need to be able to enter 05/06 and know that is a month and
a day. I need also for Excel not to automatically assume that it is
05/06/2006. Any suggestions?
Reply With QuoteReply With Quote