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?

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

--

HTH

Bob

"Rob P" <(E-Mail Removed)> wrote in message
news:f574bab6-e53d-4d72-9fec-(E-Mail Removed)...
> 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?

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:

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 exce
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 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/tutorials...n-to-auto.aspx

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 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.
>
> --
>
> 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 Text>Data To Columns, third page in the wizard.--HTHBob
> Try Text>Data 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