on this forum a helpful expert posted
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" ))

with my version i get 10 th not 10th
same with 20.
so i changed the formula 10 and 20 to 9 and 19. worked for 10th but not 20 and 30.
what do i do?
and can i change a date say january 20 2006 and using this formula to get January 20th 2006, all in one cell?
at the moment i am using a separate column for, month,day and year.
i need to copy paste them into a text file.
thanks all