Brilliant!, I just needed to think more laterally! Thanks mate.

"Gary''s Student" wrote:

With a value in A1:

=A1&IF(AND(A110,A1<20),"th",CHOOSE(MOD(A1,10)+1," th","st","nd","rd","th","th","th","th","th","th" ))

--
Gary''s Student - gsnu200826


"Spaced out." wrote:

I have a list of "day positional" dates currently displayed as 1, 2, 3, 4
...... etc, and I merely want to show 1st, 2nd, 3rd, 4th ..... I thought
this would be easy to do, but can't find it. Any ideas please on where to
look?