Prev: Excel 2010
Next: IF need to add a third value
From: Terry0928 on 5 Apr 2010 05:23
ozgrid.com wrote:
>=TEXT(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)),"mm-dd-yyyy")
>
>and copy paste special-values.
>
>> Hi,
>>
>[quoted text clipped - 10 lines]
>> Best Regards,
>> Terry

Thanks ozgrid.com
I tried and it works,
Thanks a lot.

From: "David Biddulph" groups [at] on 5 Apr 2010 05:31
=--TEXT(A1,"0000\-00\-00") and format as date to suit.
--
David Biddulph


"Terry0928" <u59143(a)uwe> wrote in message news:a610c18eb8b14(a)uwe...
> Hi,
>
> I have some data exported from a system, the date is a text displayed as
> "20100315" which should read yyyymmdd. I need to convert this text to
> another date format showing mm/dd/yyyy in text for importing into another
> system. As the text format yyyymmdd does not contain any "/" or "-" so
> using text to column will be a difficulty.
>
> Please advise how could I handle this.
>
> Thanks a lot.
>
> Best Regards,
> Terry
>

From: מיכאל (מיקי) אבידן on 5 Apr 2010 06:26
If I'm not mistaken - you have missed the important part [quote]:
....I need to convert this text to another date format showing mm/dd/yyyy !!!
IN TEXT !!! for importing into another system. [end quote]
Micky


"David Biddulph" wrote:

> =--TEXT(A1,"0000\-00\-00") and format as date to suit.
> --
> David Biddulph
>
>
> "Terry0928" <u59143(a)uwe> wrote in message news:a610c18eb8b14(a)uwe...
> > Hi,
> >
> > I have some data exported from a system, the date is a text displayed as
> > "20100315" which should read yyyymmdd. I need to convert this text to
> > another date format showing mm/dd/yyyy in text for importing into another
> > system. As the text format yyyymmdd does not contain any "/" or "-" so
> > using text to column will be a difficulty.
> >
> > Please advise how could I handle this.
> >
> > Thanks a lot.
> >
> > Best Regards,
> > Terry
> >
>
> .
>
From: "David Biddulph" groups [at] on 5 Apr 2010 06:48
I had assumed that if the OP wanted it in text for exporting to another
system, he would do so by saving the Excel output as csv or another text
format. I guessed that he knew how to do that, and that his question was
the one he asked: how to "convert this text to another date format".
--
David Biddulph


"????? (????) ?????" <micky-a*at*tapuz.co.il> wrote in message
news:5C476AAE-3E46-4EE3-BF08-D3B543A7E9FC(a)microsoft.com...
> If I'm not mistaken - you have missed the important part [quote]:
> ...I need to convert this text to another date format showing mm/dd/yyyy
> !!!
> IN TEXT !!! for importing into another system. [end quote]
> Micky
>
>
> "David Biddulph" wrote:
>
>> =--TEXT(A1,"0000\-00\-00") and format as date to suit.
>> --
>> David Biddulph
>>
>>
>> "Terry0928" <u59143(a)uwe> wrote in message news:a610c18eb8b14(a)uwe...
>> > Hi,
>> >
>> > I have some data exported from a system, the date is a text displayed
>> > as
>> > "20100315" which should read yyyymmdd. I need to convert this text to
>> > another date format showing mm/dd/yyyy in text for importing into
>> > another
>> > system. As the text format yyyymmdd does not contain any "/" or "-"
>> > so
>> > using text to column will be a difficulty.
>> >
>> > Please advise how could I handle this.
>> >
>> > Thanks a lot.
>> >
>> > Best Regards,
>> > Terry
>> >
>>
>> .
>>

From: Niek Otten on 5 Apr 2010 06:49
=TEXT(--TEXT(A1,"0000\-00\-00"),"mm/dd/yyyy")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"מיכאל (מיקי) אבידן" <micky-a*at*tapuz.co.il> wrote in message
news:5C476AAE-3E46-4EE3-BF08-D3B543A7E9FC(a)microsoft.com...
> If I'm not mistaken - you have missed the important part [quote]:
> ...I need to convert this text to another date format showing mm/dd/yyyy
> !!!
> IN TEXT !!! for importing into another system. [end quote]
> Micky
>
>
> "David Biddulph" wrote:
>
>> =--TEXT(A1,"0000\-00\-00") and format as date to suit.
>> --
>> David Biddulph
>>
>>
>> "Terry0928" <u59143(a)uwe> wrote in message news:a610c18eb8b14(a)uwe...
>> > Hi,
>> >
>> > I have some data exported from a system, the date is a text displayed
>> > as
>> > "20100315" which should read yyyymmdd. I need to convert this text to
>> > another date format showing mm/dd/yyyy in text for importing into
>> > another
>> > system. As the text format yyyymmdd does not contain any "/" or "-"
>> > so
>> > using text to column will be a difficulty.
>> >
>> > Please advise how could I handle this.
>> >
>> > Thanks a lot.
>> >
>> > Best Regards,
>> > Terry
>> >
>>
>> .
>>

First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: Excel 2010
Next: IF need to add a third value