Thread: How do I convert a number like 19660124 to 01-24-1966 in excel?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Katyfarm Katyfarm is offline
external usenet poster
  
Posts: 2
Default How do I convert a number like 19660124 to 01-24-1966 in excel?
I have a lengthy column in Excel of birthdates, written as 19660124 and I
need to convert them so they read like 01-24-1966.

Thanks!
Reply With QuoteReply With Quote