Forum Discussion
Solved
Change month only in a column containing several rows of dates
Apologize if this has been solved previously. I am attempting to change the month only in a column of already entered dates in a column. For example I have 1/2/2018, 1/5/2018, 1/17/2018, 1/20/18 etc...
If you select all your dates before Ctrl+H when Replace All shall work, otherwise find (and replace) one by one
SergeiBaklan, have tried these solutions, I do see some changes, but for the case where I have different months on same sheet, and desire to change only a month in a single column, containing a range of dates, it happens that both the dates changes (in two months, including undesired one. Even though only the desired column was selected)
*Changed a month on September to October on numeral dates accidentally and unable to undo it
Selecting the dates please check in which format they are shown in formula bar. In my case that's default ISO format even if in grid dates are formatted as mm/dd/yyyy
Make replacement based on default format. I change -08- on -09-
