S sergio789 Jul 8, 2008 #1 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 ???
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 Jul 8, 2008 #2 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.
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.
