Forum Discussion
Change month only in a column containing several rows of dates
If you select all your dates before Ctrl+H when Replace All shall work, otherwise find (and replace) one by one
Thanks, but Find and Replace won't work because I have several dates within the column.
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-
