| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Day to Date
Hi all
I have in column I dates like 5/16/2006 which show in cells as 16-May-06 how could I get them to show as, Tue-16-may-06 Thanks in advance Dave |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Add Day to Date
Just format the cell as ddd-dd-mmm-yy
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "DavidM" wrote in message ... Hi all I have in column I dates like 5/16/2006 which show in cells as 16-May-06 how could I get them to show as, Tue-16-may-06 Thanks in advance Dave |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Add Day to Date
That was a fast reply
Thanks Bob "Bob Phillips" wrote in message ... Just format the cell as ddd-dd-mmm-yy -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "DavidM" wrote in message ... Hi all I have in column I dates like 5/16/2006 which show in cells as 16-May-06 how could I get them to show as, Tue-16-may-06 Thanks in advance Dave |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Add Day to Date
Create a custom format that looks like this
Select the cells to format, click FORMAT in the menu and select CELLS and click on the NUMBER tab. Select CUSTOM from the category list and enter the following formatting mask in the TYPE: field: ddd dd-mmmm-yy for Fri 13-October-06 for a complete day of the week use dddd for an abbreviated month use mm -- Kevin Backmann "DavidM" wrote: Hi all I have in column I dates like 5/16/2006 which show in cells as 16-May-06 how could I get them to show as, Tue-16-may-06 Thanks in advance Dave |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Add Day to Date
Thanks Kevin
"Kevin B" wrote in message ... Create a custom format that looks like this Select the cells to format, click FORMAT in the menu and select CELLS and click on the NUMBER tab. Select CUSTOM from the category list and enter the following formatting mask in the TYPE: field: ddd dd-mmmm-yy for Fri 13-October-06 for a complete day of the week use dddd for an abbreviated month use mm -- Kevin Backmann "DavidM" wrote: Hi all I have in column I dates like 5/16/2006 which show in cells as 16-May-06 how could I get them to show as, Tue-16-may-06 Thanks in advance Dave |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
| Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| copy date based on date -refer to date range | Excel Programming | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Hybrid Mode
