Calc - how to enter text without the single or double quote showing?

Calc - Assume I want to enter text in a cell that has been pre assigned as a date cell (the whole column is for dates).

In MS Excel, I used to enter text into a cell by typing a single quote first, followed by the text. The leading single quote would not show in the text.

When I do the same thing in Calc, the single (or double) quote shows along with the text. How do I enter text in a date cell without the leading quote showing?

(I could assign the formatting of the single cell to “text” but that is too cumbersome compared to just entering a leading quote to tell calc that the cell should be text.)


In all the versions I used the quote entry works as expected: recognition of the input as text.

As the screenshot below shows, the quote is only displayed in the formula bar. In the cell itself (and of course in preview or print) the quote is not displayed.

One hypothesis that could explain your dysfunction would be, for example, an auto-correction that would replace the quote in another typographic sign (see for example Tools AutoCorrect options Localized

HTH - Regards

Hi pierre-yves,
Thank you for confirming that Calc should work like Excel in not showing the leading quote in the cell itself. I checked Tools > AutoCorrect options > Localized Options but could not find a culprit.
Something is wrong with my (x64) version of Calc. I’m just using Calc for personal use so I can live with the leading quote showing in the cell until someone experiences the same and posts the fix.

I have hard time formatting cell as text when the contents (text) starts with =.
When I enter:

'= something

the leading apostrophe does show and no way to “hide” it. it does show in the formula field and it does show in the printout.
When I format the cell as “text” it still shows the '. When I remove then the ’ it does treat the cell as function even though I have explicitly told it, it’s TEXT. Is there some other way to hard-force the Calc to understand that the cells in this column are TEXT and nothing else and disable all kind of function/number/guessing BS?

You only need to prefix input with ' apostrophe if it could be interpreted as numeric (number, date, time, …) and then the apostrophe shows just in the Input Bar, not as cell content. Otherwise, for text that could not be interpreted as numeric just enter the text. If you prefix text that could not be interpreted as some numeric input then the leading apostrophe is assumed to be part of the text entered. If the cell was already formatted as Text prior to input then all input entered will be text content, including a leading apostrophe, no matter whether the input could be interpreted as numeric or not.