Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert date (m/dd/yyyy) in text format into an excel recognised date
Try TextData To Columns, third page in the wizard.
-- HTH Bob "Rob P" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
where/what is the wizard
Hi,
I am also trying to convert text in the M/D/YYYY format to MM/DD/YYYY format. The solution is Try TextData To Columns, third page in the wizard...where is this? Miyo Bob Phillips wrote: Try TextData To Columns, third page in the wizard.--HTHBob 11-Mar-10 Try TextData To Columns, third page in the wizard. -- HTH Bob Previous Posts In This Thread: On Thursday, March 11, 2010 2:23 PM Rob P wrote: 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? On Thursday, March 11, 2010 2:31 PM Bob Phillips wrote: Try TextData To Columns, third page in the wizard.--HTHBob Try TextData To Columns, third page in the wizard. -- HTH Bob Submitted via EggHeadCafe - Software Developer Portal of Choice Using VSTO Add-In To Automate Frequent Excel 2007 Tasks http://www.eggheadcafe.com/tutorials...n-to-auto.aspx |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
where/what is the wizard
The wizard is a nice dialog that you get when you click on the Data|Text to
columns option on the worksheet menubar in xl2003 menus. I _think_ it's on the data tab of the ribbon somewhere in xl2007. Miyo wrote: Hi, I am also trying to convert text in the M/D/YYYY format to MM/DD/YYYY format. The solution is Try TextData To Columns, third page in the wizard...where is this? Miyo Bob Phillips wrote: Try TextData To Columns, third page in the wizard.--HTHBob 11-Mar-10 Try TextData To Columns, third page in the wizard. -- HTH Bob Previous Posts In This Thread: On Thursday, March 11, 2010 2:23 PM Rob P wrote: 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? On Thursday, March 11, 2010 2:31 PM Bob Phillips wrote: Try TextData To Columns, third page in the wizard.--HTHBob Try TextData To Columns, third page in the wizard. -- HTH Bob Submitted via EggHeadCafe - Software Developer Portal of Choice Using VSTO Add-In To Automate Frequent Excel 2007 Tasks http://www.eggheadcafe.com/tutorials...n-to-auto.aspx -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I convert date format yyyymmdd to mm/dd/yyyy | Excel Worksheet Functions | |||
Excel VBA to convert "dd.MM.yy" text to "dd/MM/yyyy" format date? | Excel Programming | |||
how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel | New Users to Excel | |||
opening excel file - date format problem: DD/MM/YYYY vs MM/DD/YYYY | Excel Programming | |||
Change a date in text format xx.xx.20xx to a recognised date format | Excel Programming |