If "smart quotes" are selected for apostrophes, the apostrophe remains visible in the cell.

如果选择“智能引号”为此处的撇号，撇号在单元格中仍然可见。