'Excel - Change format of dates
I have to change the format of a column that has dates and text into dd/mm/yy. However some of the dates are missing the year so I need to fill up the year but I am not sure how to. How can I only change the format of dates, and add the year component to dates that are missing the year? Thank you :")
Solution 1:[1]
ting-xuan-kelly Please Find The Attach Image
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Jahanzaib Sehar |