Thread: Format date with just month and year
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mark Lincoln
 
Posts: n/a
Default Format date with just month and year
In Format Cells, enter either of these as a custom format:

To get 2/06:

m/yy

To get 02/06:

mm/yy

Reply With QuoteReply With Quote