| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to format a cell to display October 21st, 2006
I understand how you can change a format for 10/21/2006 into October 21,
2006, but I want to put in the "st" part in. And once I have that format in, even if I type in 10/23/2006, then it would show October 23rd, 2006 and would show the "rd" automatically. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format Issue | Excel Worksheet Functions | |||
| how do I format a cell to display in degrees minutes seconds | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Threaded Mode
