| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Date Display? | Excel Discussion (Misc queries) | |||
| Excel date format, NOT JUST DISPLAY !! | Excel Worksheet Functions | |||
| display extension for date in excel | Excel Discussion (Misc queries) | |||
| Display Last Saved Date Excel | Excel Discussion (Misc queries) | |||
| How do I display the last saved date in an EXCEL spreadsheet? | Excel Discussion (Misc queries) | |||
Linear Mode
