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) |