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