|
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? |
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? |
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 |
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 |
| All times are GMT +1. The time now is 09:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com