Multiple cell formats in Calc

[DarkArmadillo]

Hello all,

Suppose I want to have Column A be in a date/24hr time format.
As in, for example: 3-MAR-2022 : 1900 OR 3-MAR-2022 @ 1900 (either way works for me)
How would I do the formatting?

[Zizi64]

Use some similar format code in the Cell Style what you want to apply:

DD-MMM-YYYY : HHMM

The MMM is locale dependent in the LibreOffice: it means the roman number of the month in the Hungatrian locale.

[Hrbrgr]

Number Format Codes

Scroll down there

[DarkArmadillo]

Thanks you nailed it.