Roger,

You know that all Brits can drink! The world is astounded at our capacity.

Bob


"Roger Govier" wrote in message
...
Hi Big Rick

If anyone of you are ever in England, then the drinks are on me !
Be careful there,
Bob is in Dorset, I am in Wales (but often across the border)
Don't know about Bob, but I can drink quite a lot of beer!! <vbg

--
Regards

Roger Govier


"Big Rick" wrote in message
...
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