4

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?

Szybki
  • 1,083
  • 14
  • 29

1 Answers1

1

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.

Community
  • 1
  • 1
Jim K
  • 12,824
  • 2
  • 22
  • 51