Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I want to display the date like this: Ddddd, MM/DD/YY
For example 'Monday, 12/08/2009'. However, I want a line break after the comma so that the spelled-out day and date are on different lines in the same cell. It's harder than it sounds. In the cell, the value is '12/08/2009'. But the format makes it display as Monday, 12/08/2009. I can't just put an alt+enter in the middle of the date value, as that value would no longer make sense. Is there a code I can put in a custom format that will allow me to insert a line break? Thanks, Much. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
Line Break in Cell Number Format | Excel Discussion (Misc queries) | |||
Break cell into multiple lines by line break | Excel Discussion (Misc queries) | |||
Break links automatically changes graph's date format | Excel Worksheet Functions | |||
Custom format date | New Users to Excel |