If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#13
|
|||
|
|||
Date Formatting
Dear Bob, Max, Dave & Roger
I am forever grateful for all your time, effort and patience for someone who has to have something drummed in before it sticks in my mind. I did get Rogers code to work, I couldn't with Bobs', although I sure that it is because a complete amateur is trying. If anyone of you are ever in England, then the drinks are on me ! Regards -- Big Rick "Dave Peterson" wrote: You can use format|cells|number tab Give it a custom format of: dddd(alt-0010)dd mmmm yyyy Hit and hold the alt key while typing 0010 on the numeric keypad--not above the QWERTY keys. And turn on wrap text format|cells|alignment tab But be aware that you'll have to adjust the rowheight yourself (autofitting won't work). And if you make the cell too narrow for the whole string (not after wrapping text), you'll see ###'s. ==== Another format to consider: dddd* dd mmmm yyyy This works pretty neat when you widen the column. Big Rick wrote: Hello Fellow Excellers. When I enter a date in a cell and give it a long format. e.g. dddd dd mmmm yyyy, so that it would read Monday 1 January 2006, then the wrap text facility does not work. Is there any way to put in an 'alt-enter' type character so that I could have the Monday on the first line and the rest underneath. -- Your help is and always has been very much appreciated. Thanking you in anticipation. --- --- --- Big Rick -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional formatting of date | cebubum | General Discussion | 4 | June 28th, 2005 03:27 AM |
Date Range and Average F/X Rate | David | General Discussion | 0 | June 23rd, 2005 02:26 PM |
Problem formatting date values in chart... | Private Person | Charts and Charting | 7 | October 14th, 2004 05:00 AM |
QDE (Quick Date Entry) | Norman Harker | Worksheet Functions | 37 | September 5th, 2004 01:24 AM |
QDE (Quick Date Entry) | Norman Harker | General Discussion | 3 | September 3rd, 2004 08:00 AM |