| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
display extension for date in excel
I would like to display a date typed in as 06/04/2002 as Saturday 6th April
2002 I have got as far as dddd dd mmm in the custom number type,which displays Saturday 6 April. How do you get the extension to display? Thanks, Phil |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display extension for date in excel
yyyy
Steve On Tue, 14 Nov 2006 18:38:02 -0000, Phil wrote: I would like to display a date typed in as 06/04/2002 as Saturday 6th April 2002 I have got as far as dddd dd mmm in the custom number type,which displays Saturday 6 April. How do you get the extension to display? Thanks, Phil |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display extension for date in excel
dddd dd mmmm yyy
06/04/2002 (Tuesday 4th June 2002) "Phil" wrote: I would like to display a date typed in as 06/04/2002 as Saturday 6th April 2002 I have got as far as dddd dd mmm in the custom number type,which displays Saturday 6 April. How do you get the extension to display? Thanks, Phil |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display extension for date in excel
sorry, just realized you have the day before the month.....
"Phil" wrote: I would like to display a date typed in as 06/04/2002 as Saturday 6th April 2002 I have got as far as dddd dd mmm in the custom number type,which displays Saturday 6 April. How do you get the extension to display? Thanks, Phil |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display extension for date in excel
You can do this only via Regional Settings in Control Panel of your
desktop/laptop. "Phil" wrote: I would like to display a date typed in as 06/04/2002 as Saturday 6th April 2002 I have got as far as dddd dd mmm in the custom number type,which displays Saturday 6 April. How do you get the extension to display? Thanks, Phil |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display extension for date in excel
And I bet you mean the "th" in 6th.
I don't think you'll be able to do this by formatting alone. Phil wrote: I would like to display a date typed in as 06/04/2002 as Saturday 6th April 2002 I have got as far as dddd dd mmm in the custom number type,which displays Saturday 6 April. How do you get the extension to display? Thanks, Phil -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display extension for date in excel
I added "(space)yyyy" to your existing formula and it worked for me
Lou "Phil" wrote: I would like to display a date typed in as 06/04/2002 as Saturday 6th April 2002 I have got as far as dddd dd mmm in the custom number type,which displays Saturday 6 April. How do you get the extension to display? Thanks, Phil |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display extension for date in excel
I posted yyyy
But I guess you are actually after the "st" "nd" "rd" "th" to be added after 1,2,3,4 etc TBH I don't know You can construct the string with a formula, but not perhaps what you wanted. Steve On Tue, 14 Nov 2006 18:38:02 -0000, Phil wrote: I would like to display a date typed in as 06/04/2002 as Saturday 6th April 2002 I have got as far as dddd dd mmm in the custom number type,which displays Saturday 6 April. How do you get the extension to display? Thanks, Phil |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display extension for date in excel
Because I'm a picky old turd that is easily confused may I suggest:
06/04/2002 on my computer in a custom format: dddd dd mmm yyyy = Tuesday 04 Jun 2002 'Jan, Feb, Mar, etc. 12/04/2002 formatted as: 'wanted month longer than 4 letters. dddd dd mmmm yyyy = Wednesday 04 December 2002 PLEASE if your format is not mm/dd/yy include 3 or 4 m's to remove confusion. Lou "SteveW" wrote: I posted yyyy But I guess you are actually after the "st" "nd" "rd" "th" to be added after 1,2,3,4 etc TBH I don't know You can construct the string with a formula, but not perhaps what you wanted. Steve On Tue, 14 Nov 2006 18:38:02 -0000, Phil wrote: I would like to display a date typed in as 06/04/2002 as Saturday 6th April 2002 I have got as far as dddd dd mmm in the custom number type,which displays Saturday 6 April. How do you get the extension to display? Thanks, Phil |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003: date display issue | Excel Discussion (Misc queries) | |||
| To display contents of a folder in an excel sheet using Excel MACRO | Excel Worksheet Functions | |||
| How do I set up the remainder to display in Excel? | Excel Discussion (Misc queries) | |||
| Can you display numbers as words in excel (eg. 10 as ten)? | Excel Discussion (Misc queries) | |||
| Display form from an VB application in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
