Thread: splitting and formating a number series into date/time
View Single Post
  #1  
Old August 28th, 2008, 04:58 PM posted to microsoft.public.excel.worksheet.functions
CMG8401
external usenet poster
  
Posts: 1
Default splitting and formating a number series into date/time
I have a data series that looks like:
20080127145747 (YearMonthDayHoursMinutesSeconds)

I need to break that up into two columns
Date (Month/Day/Year) and Time (Hours:Minutes:Seconds)

Please help