| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to custom format a date
Hi
I would like to custom format a date through a formula such that the following dates can be formatted as mentioned below 1-Sep-11 : 1st September 2011 2- Sep-11 : 2nd September 2011 3- Sep -11 : 3rd September 2011 4-Sep-11 : 4th September 2011 The "st", "nd", "rd" & "th" needs also to be superscripted with the Day number. Thanks for any ideas! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| custom date format | Excel Discussion (Misc queries) | |||
| Custom Date Format | Excel Discussion (Misc queries) | |||
| Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
| Looking for custom date format | Excel Worksheet Functions | |||
| Custom format date | New Users to Excel | |||
Threaded Mode
