I agree with the merit of saving the original data, but my point was that if
it doesn't allow the column width to be reduced, what is the point of having
it wrap to multiple lines, why not just use a simple form of 'dddd dd mmmm
yyyy' which still preserves the data. That is why I never use that
technique, I see absolutely no merit in it. A typical example of a good idea
badly implemented in Excel IMO (... don't get me started on charts and pivot
tables vbg).

Regards

Bob

(remove nothere from email address if mailing direct)

"Roger Govier" wrote in message
...
Hmmm....

I can see the absolute merit of Dave's keeping the date in a format for
use in further calculations (how are we going to do all those SP
formulae otherwise Bobvbg).
I can also see the OP's desire for having a nice formatting.

Me, Id' just have a good old compromise and do both. Have a hidden
column B and write the date value to that cell from my code,
unformatted, and then use that column if I needed to do any
calculations.

--
Regards

Roger Govier


"Bob Phillips" wrote in message
...
In that case, why would you want the wrap-around?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Dave Peterson" wrote in message
...
I'm not sure I'd say nullify. I (still) think that it depends on the
circumstance. If this were a header for a column full of wide
descriptions,
then I wouldn't care at all.


Bob Phillips wrote:

It is good that it keeps the original value, but the fact that you
have
to
allow cell width to cater for the full text string nullifies the
usefulness
of this technique IMO.

Bob

"Dave Peterson" wrote in message
...
One of the nicer things about using format is that the value
stays a
date,
too.
So it makes doing date arithmetic a little easier if you need it
later.



Roger Govier wrote:

Hey, that's quite sneaky Dave.
I would never have thought about entering control characters
into
the
number format.
Very effective.

--
Regards

Roger Govier

"Dave Peterson" wrote in message
...
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

--

Dave Peterson

--

Dave Peterson