Hi, I have got a column full of "dates" that are actually just text of
the form "Jun-06-2008". No matter how I change the formatting of
these cells, they are not being read as dates. Is there an automated
way for me to convert these into what Excel will recognize as dates?
Thanks very much. Excel 2007, if it makes a difference -

First thing I do with those is run them through Data>Text to Columns

Select entire column then..............

Next>Next>Column Data Format>Date>MDY and finish.


Gord Dibben MS Excel MVP

On Thu, 21 Apr 2011 06:58:23 -0700 (PDT), Peter <(E-Mail Removed)> wrote:

>Hi, I have got a column full of "dates" that are actually just text of
>the form "Jun-06-2008". No matter how I change the formatting of
>these cells, they are not being read as dates. Is there an automated
>way for me to convert these into what Excel will recognize as dates?
>Thanks very much. Excel 2007, if it makes a difference -

Hello! Thanks very much for your reply, but I am afraid I am still
stuck? I have 3 columns now, each in general format, and each
containing data, e.g. A2 = "Apr", B2 = "17", C2 = "2003". I am trying
to glue these separate pieces of data together using concatenate, but
having absolutely no luck. Do you have a moment for a further
suggestion? Thanks very much.

On Apr 21, 9:10*am, Gord Dibben <phnor...@shaw.ca> wrote:
> First thing I do with those is run them through Data>Text to Columns
>
> Select entire column then..............
>
> Next>Next>Column Data Format>Date>MDY and finish.

> On Thu, 21 Apr 2011 06:58:23 -0700 (PDT), Peter <smeldr...@gmail.com> wrote:
> >Hi, I have got a column full of "dates" that are actually just text of
> >the form "Jun-06-2008". *No matter how I change the formatting of
> >these cells, they are not being read as dates. *Is there an automated
> >way for me to convert these into what Excel will recognize as dates?
> >Thanks very much. *Excel 2007, if it makes a difference -

hi Peter,

=DATE(C2,MATCH(A2,{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"},0),B2)

--
isabelle


Le 2011-04-25 11:41, Peter a écrit :
> Hello! Thanks very much for your reply, but I am afraid I am still
> stuck? I have 3 columns now, each in general format, and each
> containing data, e.g. A2 = "Apr", B2 = "17", C2 = "2003". I am trying
> to glue these separate pieces of data together using concatenate, but
> having absolutely no luck. Do you have a moment for a further
> suggestion? Thanks very much.
>
> On Apr 21, 9:10 am, Gord Dibben<phnor...@shaw.ca> wrote:
>> First thing I do with those is run them through Data>Text to Columns
>>
>> Select entire column then..............
>>
>> Next>Next>Column Data Format>Date>MDY and finish.
>
>> On Thu, 21 Apr 2011 06:58:23 -0700 (PDT), Peter<smeldr...@gmail.com> wrote:
>>> Hi, I have got a column full of "dates" that are actually just text of
>>> the form "Jun-06-2008". No matter how I change the formatting of
>>> these cells, they are not being read as dates. Is there an automated
>>> way for me to convert these into what Excel will recognize as dates?
>>> Thanks very much. Excel 2007, if it makes a difference -
>

You don't want to split the dates across 3 columns.

When faced with choosing fixed or de-limited in step 1 of Text Wizard, choose
fixed.

If Excel tries to add split lines, delete them by d-click on the vertical
separation lines


Gord

On Mon, 25 Apr 2011 08:41:11 -0700 (PDT), Peter <(E-Mail Removed)> wrote:

>Hello! Thanks very much for your reply, but I am afraid I am still
>stuck? I have 3 columns now, each in general format, and each
>containing data, e.g. A2 = "Apr", B2 = "17", C2 = "2003". I am trying
>to glue these separate pieces of data together using concatenate, but
>having absolutely no luck. Do you have a moment for a further
>suggestion? Thanks very much.
>
>On Apr 21, 9:10*am, Gord Dibben <phnor...@shaw.ca> wrote:
>> First thing I do with those is run them through Data>Text to Columns
>>
>> Select entire column then..............
>>
>> Next>Next>Column Data Format>Date>MDY and finish.
>
>> On Thu, 21 Apr 2011 06:58:23 -0700 (PDT), Peter <smeldr...@gmail.com> wrote:
>> >Hi, I have got a column full of "dates" that are actually just text of
>> >the form "Jun-06-2008". *No matter how I change the formatting of
>> >these cells, they are not being read as dates. *Is there an automated
>> >way for me to convert these into what Excel will recognize as dates?
>> >Thanks very much. *Excel 2007, if it makes a difference -

Ah. Got it. Thanks very much - not the world's smartest question, I'm
afraid -

On Apr 25, 11:02*am, Gord Dibben <phnor...@shaw.ca> wrote:
> You don't want to split the dates across 3 columns.
>
> When faced with choosing fixed or de-limited in step 1 of Text Wizard, choose
> fixed.
>
> If Excel tries to add split lines, delete them by d-click on the vertical
> separation lines

Good to hear.

Happy to help

On Mon, 25 Apr 2011 10:15:47 -0700 (PDT), Peter <(E-Mail Removed)> wrote:

>Ah. Got it. Thanks very much - not the world's smartest question, I'm
>afraid -
>
>On Apr 25, 11:02*am, Gord Dibben <phnor...@shaw.ca> wrote:
>> You don't want to split the dates across 3 columns.
>>
>> When faced with choosing fixed or de-limited in step 1 of Text Wizard, choose
>> fixed.
>>
>> If Excel tries to add split lines, delete them by d-click on the vertical
>> separation lines