Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to convert julian date to general date | Excel Worksheet Functions | |||
Date Calculations | Excel Worksheet Functions | |||
how do I convert a UK date to a US date in excel? | Excel Discussion (Misc queries) | |||
convert julian date to gregorian date | Excel Discussion (Misc queries) | |||
How do I convert a Julian date into a regular date? | Excel Discussion (Misc queries) |