Excelmancan
New Member
- Joined
- Jun 27, 2010
- Messages
- 32
Hi Everyone,
Here is my issue. I have a large dataset that I download from an outside source from time to time. All is good except the dates. Is there a way that a formula or a macro can be created that would convert the format that is seen below in the 1st 6 example dates that we be returned in the format as seen with the balance without affecting the "good dates".
<colgroup><col></colgroup><tbody>
</tbody>
Thanks.
Here is my issue. I have a large dataset that I download from an outside source from time to time. All is good except the dates. Is there a way that a formula or a macro can be created that would convert the format that is seen below in the 1st 6 example dates that we be returned in the format as seen with the balance without affecting the "good dates".
2012-01-17 |
2012-03-17 |
2012-05-17 |
2012-08-17 |
2012-09-17 |
2012-12-17 |
12/14/17 |
12/17/17 |
12/19/17 |
12/23/17 |
12/27/17 |
12/28/17 |
12/31/17 |
<colgroup><col></colgroup><tbody>
</tbody>
Thanks.