Date Formatting
No other reason than "just because".
Actually, I like this format much better:
dddd* mm/dd/yyyy
But that's just my opinion.
Bob Phillips wrote:
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
--
Dave Peterson
|