Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I create my own date showing day of week plus date?
I would like to enter the date, such as 10/04/09, and have it show up in the
cell as: Sun 10/04/09 Is this possible? Right now all I see for formatting the date showing the day of the week shows: Sunday, October 4, 2009 (it's spelling out too much for me...I want everything abbreviated). I would like only the first 3 characters for the day of the week and then the date using numbers as xx/xx/xx. -- Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I create my own date showing day of week plus date?
Right click the cell/rangeFormat CellsSelect Category as 'Custom'. Within
the text box labeled 'Type:' enter the below ddd mm/dd/yyyy If this post helps click Yes --------------- Jacob Skaria "tjsmags" wrote: I would like to enter the date, such as 10/04/09, and have it show up in the cell as: Sun 10/04/09 Is this possible? Right now all I see for formatting the date showing the day of the week shows: Sunday, October 4, 2009 (it's spelling out too much for me...I want everything abbreviated). I would like only the first 3 characters for the day of the week and then the date using numbers as xx/xx/xx. -- Thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I create my own date showing day of week plus date?
Use the custom format of ddd m/dd/yy.
Enter the date as usual: 10/4/2009 and it will display as Sun 10/04/09. -- Biff Microsoft Excel MVP "tjsmags" wrote in message ... I would like to enter the date, such as 10/04/09, and have it show up in the cell as: Sun 10/04/09 Is this possible? Right now all I see for formatting the date showing the day of the week shows: Sunday, October 4, 2009 (it's spelling out too much for me...I want everything abbreviated). I would like only the first 3 characters for the day of the week and then the date using numbers as xx/xx/xx. -- Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert regular Date to Week Ending or Week Beginning Dates | Excel Discussion (Misc queries) | |||
Showing date as day of week | Excel Worksheet Functions | |||
Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
Finding the Monday date based on a different date in same week | Excel Worksheet Functions | |||
How can I create formula that turns a date into the week # in | Excel Discussion (Misc queries) |