Thread
:
splitting and formating a number series into date/time
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
CMG8401
external usenet poster
Posts: 1
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
Reply With Quote
CMG8401
View Public Profile
Find all posts by CMG8401