Consider your date lies in cell A1, then use the following formula to convert it into a date: =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
As for your first question, what header are you talking about...?
- Mangesh
Consider your date lies in cell A1, then use the following formula to convert it into a date: =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
As for your first question, what header are you talking about...?
- Mangesh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks