Forum Discussion
Date format
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?
What do the values look like if you apply the number format m/d/yyyy to the cells?