Assuming the numbers are integers...

Try this:

A1 = 7

Enter this formula in B1:

=A1&MID("thstndrdth",MIN(9,2*RIGHT(A1)*(MOD(A1-11,100)2)+1),2)

Credit to Rick Rothstein for the basic concept. That's the shortest ordinal
formula (using worksheet functions) I've seen.

--
Biff
Microsoft Excel MVP


"sergio789" wrote in message
...
For example if you typed 7 in one cell but in another cell where cell one
=
the 2nd cell you want it to appear as 7th not 7 ???