Date changing
Assuming your data is in column A, try this formula:
=DATE(LEFT(A1,4),MID(A1,6,2),RIGHT(A1,2))
The formula parses the text string into its representative numbers, and
supplies them as arguments in the DATE formula, which is designed to do
just this type of task. You can copy that formula down for whatever
number of rows are appropriate.
|