I have to admit that I am a little stunned that Microsoft has never included
Ordinal-formatting this as a format option in Excel-x, let alone Excel 2010. It seems so crazy that such a powerful product would not include this. All I can think is that there's some 'good reason' that they have not.
All I want is to have a series of numbers, dates, etc. that I can right-click and select an Ordinal format and have it work; without playing about with special formulae, macros, cunning conditional formatting, fancy scripting,etc.
I have tried some of the solutions offered via searches and the like, but these are without a doubt far too cumbersome for simple application, especially if you need to email spreadsheets to others that are either outside of your macro or script or office version
arena, don't know about the specialised Conditional formatting or macros.
I suspect that this is one of those little things that will perhaps just fade into obscurity. Funnily enough, it is catered to in all other Office products in auto-text, just not in Excel?
I look forward to a simple solution, preferably from Microsoft themselves.