Posted to microsoft.public.excel.programming

simsjr

external usenet poster

Posts: 19

Convert Text Column to Date?

I have a column of dates, but they're in text format. How can I convert the
text "02/05/05" into an actual date?

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 Date Time in Spreadsheet Column to Date only	Genga	Excel Programming	1	June 8th 04 08:18 PM
What is the formula to convert a whole column of date to text?	Caine Phorn	Excel Programming	2	February 9th 04 08:43 AM

All times are GMT +1. The time now is 05:03 AM.

About Us

"It's about Microsoft Excel"