I have a column with dates in AAAA-MM-DD format. Some cells appear to work right, but others include an apostrophe at the beginning. When changing their format to text (@) the ’ character disappears, but when turning it back to date it appears again. The problem is not the apostrophe itself, but its consequences when sorting, as this character is not present in all cells. Here’s an example:
1281-11-20 [1281-11-20] 1282-06-11 [1282-06-11] 1252-12-03 ['1252-12-03] 1254-01-04 ['1254-01-04]
I’ve already tried to copy the whole column and paste it as simple text in another place, but the problem persists.
Hope you can help.