Custom Number Format forcing a linebreak?

[Clearwell_T]

Hi All,

I searched for this, and I’m sure it’s super basic, but I can’t find the solution here on the forum or in the LO help file.
I want to force a line break in the Custom Number Formatting so that this:
Fri 07/03/2025 14:30:00
becomes this:
Fri 07/03/2025
14:30:00.000
in a cell that needs to maintain it’s underlying number status for use in further calculations.
Any help is much appreciated.
Regards.
CT

[Lupp]

@Clearwell_T

…in a cell that needs to maintain it’s underlying number status for use in further calculations.

Also textual DateTime values can be used in calculations if they have a format sufficiently close to the ISO 8601 standard. They are automatically converted then. Texts containing hard breaks or other fancy specialties are not eligible for this feature.
See example:
disask119932_fancyDateTimeFotrmatting.ods (31.4 KB)

[Wanderer]

You need to include/concat CHAR(10), but as you can not call a function in a format, you should do the conversion outside of the format. But this will collide with your other condition “maintain it’s underlying number status”.

Workaround (fragile) allow the format to wrap lines and fill with additional spaces before the time, so LibreOffice will insert the line-break for you

Inserting a paragraph mark in a Calc function

Can you insert a paragraph mark on a calc function to produce a correct name and address. This is what I want Kathleen X, Director, Government Affairs Central Maine Power Co One City Center, 5th Floor Portland ME 04101 Portland, ME 04101 To convert to this: Kathleen X, Director, Government Affairs Central Maine Power Co One City Center, 5th Floor Portland ME 04101 =F2 & ___ & G2 & ___ & h2 & ___ & L2 What do I put int the ___ spaces? And don’t tell me to use the Mail Merge Wizard. It …

I’m not aware of a way to use some hex-notation for LF in the format-codes and didn’t test if it can be included via special characters

Calc cell number format: Fill space with unicode character?

I want to use the Calc number format option “asterisk+character” to fill the space in a cell with a special character between the dollar sign on the left and the number on the right. To fill with a space, the cell number format would be: “$”* #,##0.00 To fill with a period, the cell number format would be: “$”*.#,##0.00 What would the cell number format be to replace the space or the period after the asterisk with a unicode character? In my case, I want to use the “hair space” (U+200A). Do I …