hello
I have a column of cells formatted as dates.
Some of them have the full date (day,month,year) but some only list the years. I want to clear the contents of the cells with only years, how do I do that?
cells formatted as date with only a year in them
That’s impossible with real calc dates (assuming all cells share a common date format). You seem to deal with Text and not dates, which are numbers counting the days since 1899-12-30 (day 0) - or with a mixture of real dates and numbers/text.
I’d suggest you provide (part) or your file, to see what you really have. To upload a file, edit* your question and use the paperclip symbol.
In my environment, the editable content of date cells only showing the year (e.g. 1899) is like 31/12/1899 (you can see it in the Input line, or when pressing F2).
If your full date cells are formatted as 31,12,1899 (not with slash, I use the dash), then you can select the column of dates, Find for /, and delete the resulting selection.
Tested with LibreOffice 7.0.6.2 (x64); OS: Windows 10.0.
Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information. Thanks.
Check the mark (
→ 
) to the left of the answer that solves your question (it may take a little while until it turns green).