Date format

Copper Contributor

I have a column of dates where the year is absent. Thy look like this; 2/2, 2/3, 2/5, etc.

Do I need to go to each cell and enter the year or is there a function that can help me to fill the year?

1 Reply


What do the values look like if you apply the number format m/d/yyyy to the cells?