Display numbers as ordinals

[Tobias Weber]

Hi,
how do I get numbers (1 2 3) to show up as English ordinals (1st 2nd
3rd) on a chart axis? Can't find the format code.

 

[Niek Otten]

Hi Tobias,

There is no format code to do that.

Look here for two solutions:

http://www.cpearson.com/excel/ordinal.htm