Can you change normal numbers to ordinal numbers ?

S

sergio789

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 ???
 
T

T. Valko

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.
 
Top