PC Review


Reply
Thread Tools Rate Thread

Change Excel cell format date type examples ("14-Mar-01")

 
 
=?Utf-8?B?Q29naXRvLmVyZ28uc3Vt?=
Guest
Posts: n/a
 
      16th May 2005
Formatting:
A detail which makes the response to the user "not exact/unique":
Take the following path in any cell: Format / Number / Date / Type
Say you have a “single digit” date; example: 3-May-05.
Choose the first of two : “14-Mar-01” what will the format be?
Choose the second, identical: “14-Mar-01”, what will the format be?
50%-50% chance one of them will give you a leading zero, the other will
suppress the zero. The user finds out after he executes the formatting, not
before.

Shouldn’t we use more explicit examples such as: “ 4-Mar-01” and
“04-Mar-01” ?


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...ic.excel.setup
 
Reply With Quote
 
 
 
 
George Nicholson
Guest
Posts: n/a
 
      17th May 2005
1) Actually, I think you'll find that the formats are "sorted" (within
groupings) by increasing # of characters: 1st example has no leading zero,
2nd example does. I've always found that to be pretty consistent. The list
isn't especially random.
2) While your " 4-Mar-01" and "04-Mar-01" would work for formats that
include text, 4-03-01 and 04-03-01 would raise the question "Which is the
day and which is the month?" (i.e., there is a reason one of the numbers in
the "type" samples is always greater than 12, and thus can't show leading
zeros in the example).
3) "The user finds out after he executes the formatting, not before." Huh?
There is a "sample" box in that dialog that shows exactly how the value in
the currently selected cell would appear with the currently selected format,
before the user exits the dialog and "executes" anything.

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"Cogito.ergo.sum" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Formatting:
> A detail which makes the response to the user "not exact/unique":
> Take the following path in any cell: Format / Number / Date / Type
> Say you have a "single digit" date; example: 3-May-05.
> Choose the first of two : "14-Mar-01" what will the format be?
> Choose the second, identical: "14-Mar-01", what will the format be?
> 50%-50% chance one of them will give you a leading zero, the other will
> suppress the zero. The user finds out after he executes the formatting,
> not
> before.
>
> Shouldn't we use more explicit examples such as: " 4-Mar-01" and
> "04-Mar-01" ?
>
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow
> this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...ic.excel.setup



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
COVER LETTERS RESUME EXAMPLES AND CV EXAMPLES AVAILABLE rawebadvert3 Windows XP General 3 23rd Dec 2009 05:47 PM
RESUME EXAMPLES / CV EXAMPLES NOW AVAILABLE THROUGH RESUMEWRITERGUIDE.COM rawebadvert3 Windows XP Basics 7 27th May 2007 04:16 AM
RESUME EXAMPLES / CV EXAMPLES NOW AVAILABLE THROUGH RESUMEWRITERGUIDE.COM rawebadvert Microsoft VB .NET 0 9th May 2007 03:57 AM
Looking for Userform examples - site on web, download examples =?Utf-8?B?dGhvbSBob3lsZQ==?= Microsoft Excel Programming 1 10th May 2005 05:23 PM
"View Some Examples" on Add Network Place" does not show any examples =?Utf-8?B?Um9nZXI=?= Windows XP Networking 2 17th Feb 2004 06:21 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:27 AM.