View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RyanR8881 RyanR8881 is offline
external usenet poster
 
Posts: 6
Default inserting comma into date text

If I have a column of dates that look like

OCT 10 2007
OCT 10 2007
OCT 08 2007
NOV 07 2007

How can I insert a comma after the Days before the year in order to make
excel recognize all three parts as one date.