Convert alphanumerical(eg. 12.11.2005) to date as 12-Nov-2005 in e
 

Hi,
How to Convert alphanumerical(eg. 12.11.2005) to date as 12-Nov-2005 in excel.

Will any body help in sorting this prblm..

Convert alphanumerical(eg. 12.11.2005) to date as 12-Nov-2005 in e
 

Say you have 12.11.2005 in A1
Enter:
=DATEVALUE(SUBSTITUTE(A1,".","/"))

HTH
--
AP

"Safi" a écrit dans le message de news:
...
Hi,
How to Convert alphanumerical(eg. 12.11.2005) to date as 12-Nov-2005 in
excel.

Will any body help in sorting this prblm..

Convert alphanumerical(eg. 12.11.2005) to date as 12-Nov-2005 in e
 

Hi Safi,

With the alaphanumeric cells selected, try:

(1) Edit | Replace | What: . | With: / (period == backslash)

Alternatively,

(2) Data | Text to Columns | Delimited | Next | Next
Select the Date option | Finish


---
Regards,
Norman



"Safi" wrote in message
...
Hi,
How to Convert alphanumerical(eg. 12.11.2005) to date as 12-Nov-2005 in
excel.

Will any body help in sorting this prblm..

Convert alphanumerical(eg. 12.11.2005) to date as 12-Nov-2005 in e
 

=TEXT(DATE(RIGHT(A1,4),MID(A1,4,2),LEFT(A1,2)),"dd-mmm-yyyy")

assuming input format is always dd.mm.yyyy

HTH


"Safi" wrote:

Hi,
How to Convert alphanumerical(eg. 12.11.2005) to date as 12-Nov-2005 in excel.

Will any body help in sorting this prblm..