Re: Converting dates

From: "CLR" <croberts@xxxxxxxxxxxxxxx>
Date: Tue, 6 Sep 2005 18:07:15 -0400

If you have a "text" date, in A1, use this.........
=RIGHT(A1,4)&MID(A1,FIND("/",A1,1)+1,2)&LEFT(A1,2)

Vaya con Dios,
Chuck, CABGx3

"Ana" <aslopez@xxxxxxxx> wrote in message
news:#LYC1ZxsFHA.1344@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> I need to convert the date format dd/mm/yyyy to yyyymmdd.
>
> How would I go by?
>
> TIA
>
> Ana
>
>

.

References:
- Converting dates
  - From: Ana

Prev by Date: Re: how can I multiply 7feet and 6ft 8in?
Next by Date: Re: How can you append text in multiple cells in excel?
Previous by thread: Re: Converting dates
Next by thread: Re: Converting dates
Index(es):
- Date
- Thread

Relevant Pages

Re: GOTO another sheet
... Vaya con Dios, ... > TIA ... > Chuck, CABGx3 ...
(microsoft.public.excel.programming)
Re: A file by any other name.......
... > Tim. ... then the macro finds it and runs fine. ... >> TIA ... >> Vaya con Dios, ...
(microsoft.public.excel.programming)
Converting dates
... I need to convert the date format dd/mm/yyyy to yyyymmdd. ... TIA ... Ana ... Prev by Date: ...
(microsoft.public.excel.newusers)
Re: returning a value according to characters
... Vaya con Dios, ... return a value in another cell. ... > TIA ...
(microsoft.public.excel.newusers)