Thread: Date to change format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default Date to change format
presuming item1 is in A1, try:

=MONTH(A1)&"/"&YEAR(A1)
Reply With QuoteReply With Quote