Custom formatting a number to show day# as "'st" "nd" "rd" and "th"

Here's the help file that describes all of the number formatting codes you can use in a spreadsheet. https://support.microsoft.com/en-us/...rs=en-us&ad=us

I do not see any way to get this kind of formatting as a number format. I expect one could use a TEXT() function with appropriate logic in the format code parameter and convert the date to a text string with the appropriate text suffix, but, of course, there can be issues with dates stored as text. How important is it to get this exact display? Is it worth the effort to convert the date to text with the corresponding issues, or would it be preferable to display the date as is with one of the available built in formats?

Edit: I see you have opted to convert to a text string.

Thanks, yes its an issue as i cant sort by text. My amateur workaround is that ive set my workbook up to so that i have a data dump on one sheet that has a number column (1,2,3 etc) and and a formatted column (1st, 2nd, 3rd etc), then i have another sheet with a (prettier!) dashboard that runs a vlookup. So in there, the number is shown as formatted value its looking up. Its not ideal.... but if i need to arrange by date, i do it on the data dump sheet, and the dashboard just spits out the date as the formatted number using vlookup! If thats makes sense?

Granted, it probably sounds a little OCD, but it helps when you just want to see a date for when something is due and its a formatted date, not just a random number. It would make sense to me, but to someone who hasnt spent a day in here, seeing nd, th, st etc.. its instantly recognisable what that number is.