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

[Rob P]

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?

 

[Bob Phillips]

Try Text>Data To Columns, third page in the wizard.

 

[Miyo]

Hi,

I am also trying to convert text in the M/D/YYYY format to MM/DD/YYYY format. The solution is Try Text>Data To Columns, third page in the wizard...where is this?

Miyo



Bob Phillips wrote:

Try Text>Data To Columns, third page in the wizard.--HTHBob
11-Mar-10

Try Text>Data To Columns, third page in the wizard

-

HT

Bob

Previous Posts In This Thread:

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 exce
recognised date

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

Try Text>Data To Columns, third page in the wizard.--HTHBob
Try Text>Data To Columns, third page in the wizard

-

HT

Bob


Submitted via EggHeadCafe - Software Developer Portal of Choice
Using VSTO Add-In To Automate Frequent Excel 2007 Tasks
http://www.eggheadcafe.com/tutorial...60-39a86ccab5d6/using-vsto-addin-to-auto.aspx

 

[Dave Peterson]

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.