Hello all.
In LibreOffice Calc, is it possible to convert a cell in text only?
I mean, when entering, for example, the text “June 2022”, it convert it into a mathematical formula. I don’t know what have I done but I already tried to convert the cells but with no success.
Thank you
Try
’June 2022
2 Likes
Yes, that one I already used. But I’m looking for a more permanent solution, one that doesn’t make me puting that ’ each time I write something…
Thank you anyway!
Pre-format cells with the Text @ number format before input (Ctrl+1 for dialog, tab Numbers). Anything entered into a cell formatted as Text will stay text.
However, if you entered June 2022 and it was converted to date 2022-06-01 or 01/06/22 or some such, you can also apply the date format
MMMM YYYY
to display it as June 2022 again.
2 Likes
That’s it! Many thanks for your great help!
1 Like