Convert date (m/dd/yyyy) in text format into an excel recognised date

Posted to microsoft.public.excel.programming

external usenet poster

Posts: 15

Convert date (m/dd/yyyy) in text format into an excel recognised date

is there anyway to convert a TEXT field with a date into an excel
recognised date?

or the other way around - convert a date in excel into text output?

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
how do I convert date format yyyymmdd to mm/dd/yyyy	Datahead	Excel Worksheet Functions	3	May 11th 23 11:45 AM
Excel VBA to convert "dd.MM.yy" text to "dd/MM/yyyy" format date?	Paul J[_2_]	Excel Programming	4	July 11th 07 11:32 AM
how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel	Jack Wilson	New Users to Excel	4	July 18th 06 01:57 PM
opening excel file - date format problem: DD/MM/YYYY vs MM/DD/YYYY	yung	Excel Programming	2	March 18th 05 12:50 PM
Change a date in text format xx.xx.20xx to a recognised date format	concatenator	Excel Programming	1	November 24th 03 11:33 PM

All times are GMT +1. The time now is 10:02 PM.

Menu

About Us