| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Format
How do I format a date
05/30/07 into Wednesday, May 30, 2007 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Format
Select the cell
press Ctrl-1 and choose the Number tab in the left panel choose Date in the right panel scroll select the format that looks like the style you want click on OK "ACarella" wrote: How do I format a date 05/30/07 into Wednesday, May 30, 2007 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Format
Hi Duke:
I did that and that format is not in the drop down. Any suggestions? "Duke Carey" wrote: Select the cell press Ctrl-1 and choose the Number tab in the left panel choose Date in the right panel scroll select the format that looks like the style you want click on OK "ACarella" wrote: How do I format a date 05/30/07 into Wednesday, May 30, 2007 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Format
Hi,
use this custom format in format-- cells--number, slect custom and then type this in the box dddd, dd mmm, yyyy "ACarella" wrote: How do I format a date 05/30/07 into Wednesday, May 30, 2007 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Format
Then instead of Date choose Custom from the left panel, then in the Type box
enter dddd, mmmm dd, yyyy "ACarella" wrote: Hi Duke: I did that and that format is not in the drop down. Any suggestions? "Duke Carey" wrote: Select the cell press Ctrl-1 and choose the Number tab in the left panel choose Date in the right panel scroll select the format that looks like the style you want click on OK "ACarella" wrote: How do I format a date 05/30/07 into Wednesday, May 30, 2007 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Format
thank you.
"DazzaData" wrote: Hi, use this custom format in format-- cells--number, slect custom and then type this in the box dddd, dd mmm, yyyy "ACarella" wrote: How do I format a date 05/30/07 into Wednesday, May 30, 2007 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Format
thank you.
"Duke Carey" wrote: Then instead of Date choose Custom from the left panel, then in the Type box enter dddd, mmmm dd, yyyy "ACarella" wrote: Hi Duke: I did that and that format is not in the drop down. Any suggestions? "Duke Carey" wrote: Select the cell press Ctrl-1 and choose the Number tab in the left panel choose Date in the right panel scroll select the format that looks like the style you want click on OK "ACarella" wrote: How do I format a date 05/30/07 into Wednesday, May 30, 2007 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| day/month/year in incorrect format for date format | Excel Worksheet Functions | |||
| How can I convert a date format to an ISO week format (in EXCEL)? | Excel Discussion (Misc queries) | |||
| Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
Linear Mode
