Convert Dates To Excel Formatted Dates

If you work with Excel, sooner or later you will encounter a problem with dates. Particularly if these dates have been imported from another program. Let's look at some of the date formats that you may encounter and also how to convert these to standard Excel dates.



For example

In cell A2: 112303


Formula Used:-

=VALUE(LEFT(A2,2)&"/"&MID(A2,3,2)&"/"&RIGHT(A2,2))



Results:-

11/23/03

Come and visit excelfanactics.com