Forum Discussion
Bizarre Bug, replacing a hyphen with nothing using Find and Replace replaces hyphen with apostrophe
Very confusing issue, when I use find and replace - with nothing (to delete all the hyphens in my document) instead of doing so it leaves an apostrophe which is visible from the formula bar but not o...
An apostrophe ' as prefix specifies that the following value is to be treated as text, even if the value looks like a number or date.
It does no harm - the apostrophe will not be printed.