Thread: Format date with just month and year
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Doug Kanter
 
Posts: n/a
Default Format date with just month and year
"Jay3253" wrote in
message ...

I need to format a cell so the date automatically changes when the month
changes. The output I need is 2/06 or 02/06 and when the month changes
it should change to 3/06 or 03/06. Thank you

Have you tried clicking (on the menu) Format, Cells, and experimenting with
what you see there?


Reply With QuoteReply With Quote