| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to specify this date format?
JE McGimpsey wrote:
One way: Format/Cells/Number/Custom "ddd dd mmmm yyyy" In article , Terry Pinnell wrote: Is there any way to specify that a date entered as say 20/12/08 should be displayed in Excel 2000 as 'Sat 20 December 2008' please? Even better, 'Saturday 20th December, 2008'? Thanks all, much appreciated. I've gone for "ddd dd mmmm yyyy" for the time being but will try the more complex alternatives later. -- Terry, East Grinstead, UK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert serial date format to normal date format | Excel Discussion (Misc queries) | |||
| Convert date from text format to date format | Excel Discussion (Misc queries) | |||
| Convert date + time text format to date format | Excel Worksheet Functions | |||
| Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
| Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
Hybrid Mode
