Posted to microsoft.public.excel.worksheet.functions

Posts: n/a

Convert text string to date

How do you convert a text string, "112905" to a date of 11/29/05?

So it has the appropriate serial value 38685 for 11/29/05.

Thanks in advance

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 Text to DATE	Dimmer	Excel Discussion (Misc queries)	8	January 22nd 09 01:15 PM
How do I convert a text string into a date?	JJMCDD02	Excel Worksheet Functions	4	November 25th 05 12:35 PM
Convert Text Entry to Date Format	User	Excel Discussion (Misc queries)	1	November 16th 05 08:40 PM
can you find specific text in a string ignoring any other text	chriscp	Excel Discussion (Misc queries)	1	September 18th 05 09:54 PM
Auto convert an alphanumeric string (CIS9638S) to numbers only?	Gary L Brown	Excel Worksheet Functions	1	September 7th 05 01:17 AM

All times are GMT +1. The time now is 04:36 PM.

About Us

"It's about Microsoft Excel"