Forum Discussion
Convert numbers to ordinal numbers (1st, 2nd, 3rd, etc.)
I suggested to a client they should stop entering ordinals (text values) and use numbers instead to facilitate sorting and calculations. I wish Excel had a number format for this, but it doesn't. I c...
First Set of formulas doesn't work for me. Im using office 2010. I couldn't try the Lamda.
so created the below sets. Might be useful for someone.
=IF(AND(1*RIGHT(A1, 2)>3,1*RIGHT(A1, 2)<21),A1&"th",IF(1*RIGHT(A1, 1)=1,A1&"st",IF(1*RIGHT(A1, 1)=2,A1&"nd",IF(1*RIGHT(A1, 1)=3,A1&"rd",A1&"th"))))
Thank you. yours was the only version that worked.