ExcelBanter - How to set the day date in excel to display 1st, 2nd, etc...?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to set the day date in excel to display 1st, 2nd, etc...? (https://www.excelbanter.com/excel-discussion-misc-queries/216591-how-set-day-date-excel-display-1st-2nd-etc.html)

Spaced out.

How to set the day date in excel to display 1st, 2nd, etc...?

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?

Gary''s Student

How to set the day date in excel to display 1st, 2nd, etc...?

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?

Spaced out.[_2_]

How to set the day date in excel to display 1st, 2nd, etc...?

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?

All times are GMT +1. The time now is 04:40 PM.