| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
"dominicb" wrote: Good afternoon Malcolm Agingwell Would the date in the format "31 January 2005" be of any use to you? If so, set up a custom format of dd mmmm yyyy. Excel doesn't handle ordinals (1st, 2nd, 3rd etc) on its own. HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=383071 Thanks this is very close to what's required. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to merge a date file into an excel format | Excel Discussion (Misc queries) | |||
| How do I report a Date Format bug in Excel 2003 to Microsoft ? | Excel Discussion (Misc queries) | |||
| Converting a date in Excel 2002 to a Year/Quarter format | Excel Worksheet Functions | |||
| Why can't I format cells in Excel 2000? | Excel Discussion (Misc queries) | |||
| How do I unhide the cell format function in Excel 2000 | Excel Worksheet Functions | |||
Hybrid Mode
