Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date format
Hi! I have a program that exports data to Excel. The problem is that the
dates are in a format that is not recoginzed by Excel as dates. They look like: 1997-maj-08, 1997-sep-24, 2005-jan-10 and so on. Is there any way to covert these dates into normal Excel dates? If you know of a solution in VBA instead of a worksheet function that would fine too! Thanks alot! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date format
First make sure that month names appearing in exported dates (maj, sep, jan)
match short month names in your Excel national language version! If yes, then this formula will do the job: =DATE(LEFT(A1,4),MONTH(DATEVALUE(MID(A1,6,6))),RIG HT(A1,2)) If not then you have to replace month names like this (it's an example for Hungarian language version: maj is replaced by máj, sep is replaced by sze) =DATEVALUE(MID(SUBSTITUTE(SUBSTITUTE(A1,"maj","má j"),"sep","sze"),6,6)) Regards, Stefi Arne Hegefors ezt *rta: Hi! I have a program that exports data to Excel. The problem is that the dates are in a format that is not recoginzed by Excel as dates. They look like: 1997-maj-08, 1997-sep-24, 2005-jan-10 and so on. Is there any way to covert these dates into normal Excel dates? If you know of a solution in VBA instead of a worksheet function that would fine too! Thanks alot! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert European Date format to American Format | Excel Discussion (Misc queries) | |||
Convert date from text format to date format | Excel Discussion (Misc queries) | |||
Convert date + time text format to date format | Excel Worksheet Functions | |||
Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) |