Any suggestions on how to apply a format that will give ordinal numbers - ie 1st, 2nd, 3rd, 4th etc.
G george ross Mar 1, 2004 #1 Any suggestions on how to apply a format that will give ordinal numbers - ie 1st, 2nd, 3rd, 4th etc.
J Jim Cone Mar 1, 2004 #2 George, Chip Pearson has a solution that worked for me... http://www.cpearson.com/excel/ordinal.htm Regards, Jim Cone San Francisco, CA
George, Chip Pearson has a solution that worked for me... http://www.cpearson.com/excel/ordinal.htm Regards, Jim Cone San Francisco, CA
B Bob Phillips Mar 1, 2004 #3 Hi George, Here is one way =A1&CHOOSE((A1<>{11,12,13})*MIN(4,MOD(A1,10))+1,"th","st","nd","rd","th") -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
Hi George, Here is one way =A1&CHOOSE((A1<>{11,12,13})*MIN(4,MOD(A1,10))+1,"th","st","nd","rd","th") -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
