Posted to microsoft.public.excel.worksheet.functions

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
splitting date and time information in cells	mebsmith	Excel Discussion (Misc queries)	5	August 26th 08 09:06 PM
Splitting Date and Time	Cita	Excel Discussion (Misc queries)	4	July 11th 08 04:20 PM
Formating into date and time	Daniel	Excel Discussion (Misc queries)	2	August 9th 07 05:02 PM
Time Series Chart Data Plot Line ''Disappears'' When Y Axis Formating Is Changed	John Burke	Charts and Charting in Excel	8	July 30th 07 03:10 PM
Number Formating Cells (Time)	onlyinsyder	Excel Discussion (Misc queries)	6	September 16th 06 08:09 AM

All times are GMT +1. The time now is 10:38 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us