A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Date Formatting



 
 
Thread Tools Display Modes
  #11  
Old January 8th, 2006, 05:13 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default 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

  #12  
Old January 8th, 2006, 06:00 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default Date Formatting

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



  #13  
Old January 8th, 2006, 06:10 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default Date Formatting

I work at a swimming pool in Blackpool.
There are 300,000 gallons of 'drink' to go at !!
--
Big Rick


"Roger Govier" wrote:

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




  #14  
Old January 8th, 2006, 06:11 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default Date Formatting

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
  #15  
Old January 8th, 2006, 06:17 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default Date Formatting

Hi Big Rick

I won't beat a trail up the M6 too quickly theng
--
Regards

Roger Govier


"Big Rick" wrote in message
...
I work at a swimming pool in Blackpool.
There are 300,000 gallons of 'drink' to go at !!
--
Big Rick


"Roger Govier" wrote:

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






  #16  
Old January 8th, 2006, 06:32 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default Date Formatting

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





  #17  
Old January 8th, 2006, 06:41 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default Date Formatting

Hi Bob

Then before too long, I must travel down to your neck of the woods and
enjoy a pint of Badger with you.

--
Regards

Roger Govier


"Bob Phillips" wrote in message
...
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







  #18  
Old January 8th, 2006, 06:43 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default Date Formatting

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



  #19  
Old January 8th, 2006, 07:03 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default Date Formatting

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
  #20  
Old January 8th, 2006, 08:01 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default Date Formatting


fantastic indeed!!!

-via135


Roger Govier Wrote:
Hi Big Rick

I won't beat a trail up the M6 too quickly theng
--
Regards

Roger Govier


"Big Rick" wrote in message
...
I work at a swimming pool in Blackpool.
There are 300,000 gallons of 'drink' to go at !!
--
Big Rick


"Roger Govier" wrote:

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






--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=499157

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 10:45 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.