I have a large spreadsheet. I’ve copied an old sheet for reuse, and need to update the copy with current information. Some of the fields are in the format:
'January 2014. I use search and replace to change all instances of 2014 to 2017. When I do this, the above field is changed to say
01/01/2017. It doesn’t just say that in the sheet: it says it in the entry line. So the Find & Replace has found the 2014, replaced it with 2017, then stripped the
' indicating that this should be treated as text, reformatted to a date, and entered the reformatted info into the cell, thus destroying actual information. How do I get it to stop this? If there is no good, simple, automatic way, how do I file this as a bug report?
Further information: When I replace one at a time, rather than doing a global replace, and the same thing happens, if I click undo, it only undoes the replacement, but keeps the incorrect reformatting, so that the field will now say