How to convert a number to an ordinal?

I had a look at the Number Format Codes page in the LibreOffice Help. It shows a lot of useful date conversions and I was hoping it would include converting cardinals to ordinals but I don’t see that. E.g.

1 -> 1st
2 -> 2nd
3 -> 3rd

Is there a standard way of doing this in Libre Office?

Edit: I realised that the date formats I mentioned are irrelevant in the context of my question.


Use the new Fontfeatures of Linux Libertine G and Linux Biolinum G,

for Example:
Cellformat with Fontname Linux Libertine G:name=3
and FontLanguage: English(USA)

more Infos Fonts

As I read the question, it doesn’t worry about superscript letters but only about the assignment of traditional notational letter-pairs (a problem that should never have arisen taking notations of numbers as basically different from abbreviating words; cf German).

However, the assignment can be done

a) explicitly using a concatenating formula like the below suggested one


b) applying a properly defined conditional format.

You may also use the named cell styles as parameters to the STYLE function.

a) will convert the value into a text containing the “ordinal notation”. b) will leave a numeric value and only apply a format.

See attached: ask50616FreakishOrdinals001.ods