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.)