Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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