| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Format date in excel 2000 like '31st January 2005'
Trying to set up field in Excel Data Source file so that the current date can
be input in letters typed in this format '31st January 2005' Is it possible or am I stuck with dd/mmm/yy format? |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
"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 | |||
Linear Mode
