| 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
|
|||
|
|||
|
Malcolm,
Why not just format it as you want, but input as standard dd/mm/yyyy. You can't (easily) get the 1st 2nd etc, but a format of dd mmmm yyyy is quite close. -- HTH Bob Phillips "Malcolm Agingwell" wrote in message ... 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? |
| 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
