Posted to microsoft.public.excel.misc

Samuel

external usenet poster

Posts: 26

convert text to date

I have a text column 02/21/08 2315

I want to convert this to an actual date/time column keeping in military
format.

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
convert a text date to a true date	JR Hester	Excel Discussion (Misc queries)	20	November 15th 07 07:15 PM
how do i convert text to date (mm/yy text to mm/dd/yyyy date)?	lindsey	Excel Discussion (Misc queries)	1	July 27th 07 10:05 PM
Help: How do I convert a text date into a real date format	japorms	Excel Worksheet Functions	4	August 2nd 06 06:36 PM
Convert a Date to Text?	Dave76Mizzou	Excel Worksheet Functions	1	March 9th 06 01:32 AM
How to convert date to text	galsaba	Excel Discussion (Misc queries)	2	May 22nd 05 08:31 PM

All times are GMT +1. The time now is 03:09 PM.

About Us

"It's about Microsoft Excel"