LibreOffice Calc new line in cell format code

6.3k Views Asked by At

Is it possible to put new line character in cell format code? For example to have week day name under the date in the same cell?

1

There are 1 best solutions below

0
On

Instead of a format code, use a formula. Either enter CHAR(10), or press Ctrl+Enter in a different cell and then reference that cell in the formula.

=TEXT(TODAY(), "DD-MMM-YYYY") & CHAR(10) & TEXT(WEEKDAY(TODAY()),"DDDD")

See https://superuser.com/questions/85439/how-can-i-make-a-newline-in-an-openoffice-org-calc-formula.

Be sure that the row is tall enough to show both lines.