Is there a way to convert a date cell into a text cell?

I have a sheet that contains date cells and would like to use the date contained in that cell as text in the title of a chart. Is there a way to do this? If so what is the procedure/method?

See another answer at Adding a cell reference to a chart text box

To convert a date in a cell to text, select the cell, choose menu Data - Text to Columns…, select the column heading, and choose Text as Column Type:.

But you couldn’t use this cell content in a formula for the title of the chart. But…

A workaround: If Chart Area is set to none,¹ the background cells could be seen. So, if in a cell behind the chart is a date, it will be seen: format it as a title. Also could set a (white) background color to the cells behind the chart.

See sample file.

To export the chart, select the cells behind the chart, choose menu File - Export… - check Selection, and select Name: and Type:

¹ Secondary click on the chart, choose Edit, choose menu Format - Chart Area… - Area tab - None button.

Tested with LibreOffice (x86); OS: Windows 6.1.

Add Answer is reserved for solutions.

Press edit below your question if you want to add more information; also can comment an answer.

Check the mark (Correct answer mark) to the left of the answer that solves your question.

Thanks for your solution it’s a bit of work but it worked great.

You’re welcome!