Groups > microsoft.public.excel.programming > #110651

Re: Check how date is entered

From	dpb <none@none.net>
Newsgroups	microsoft.public.excel.programming
Subject	Re: Check how date is entered
Date	2018-05-08 14:59 -0500
Organization	Aioe.org NNTP Server
Message-ID	<pcsvj0$4f6$1@gioia.aioe.org> (permalink)
References	(26 earlier) <pcrg7h$1ds3$1@gioia.aioe.org> <pcs2kp$s2j$1@dont-email.me> <pcsd6c$12hj$1@gioia.aioe.org> <pcsreb$1sv9$1@gioia.aioe.org> <pcss7k$ko7$1@dont-email.me>

Show all headers | View raw

On 5/8/2018 2:02 PM, GS wrote:
>> 1) Enter 5/6/2017 into A1 and A2 initially formatted as General
>> 2) Observe the Excel converted both to Date as mm/dd/yyyy
>> 3) Apply Custom format of dd/mm/yyyy to A2
>> 4) Observe the display change to 6/5/2018 -- looks good, doesn't it?
>> 5) Enter =A1 and =A2 into B1 and B2
>> 6) Format B1 and B2 as d-mmm
>> 7) Observe both read 6-May!!!
> 
> Of course it does! What were you expecting?

Well, I wasn't absolutely positive which is why I did it!  :)

My previous thought was that the date format selection actually did do 
an implicit conversion rather than being just the format of moving 
fields around.  That there's reasons I grok; I was "underneath the 
impression" as my former colleague Mr. Malaprop was wont to say that one 
could manage to recast that way; clearly I was wrong and I'm guessing in 
the subject thread the OP is as well.

> If you format all the cells as Text, you'll see that the underlying 
> DateSerial for the value entered is 43226 (May 6, 2018). It doesn't 
> matter how you format it to display because the DateSerial drives the 
> result. My point is *why deliberately use an ambiguous format* to 
> display dates given the issue? This is what my exercise demos

Well, as the other follow-up comments, sometimes one doesn't have the 
choice of what input format to use and I was trying to figure out how 
the OP could solve his problem under those constraints.

Sometimes ideal solutions are just not available in the real world.

Can you illustrate the idea of the template for the ignorant? :)

--

Thread

Check how date is entered jan120253@gmail.com - 2018-05-04 00:31 -0700
  Re: Check how date is entered dpb <none@none.net> - 2018-05-04 07:46 -0500
    Re: Check how date is entered "Auric__" <not.my.real@email.address> - 2018-05-04 15:55 +0000
      Re: Check how date is entered dpb <none@none.net> - 2018-05-04 12:43 -0500
        Re: Check how date is entered GS <gs@v.invalid> - 2018-05-04 17:37 -0400
          Re: Check how date is entered dpb <none@none.net> - 2018-05-04 18:49 -0500
            Re: Check how date is entered GS <gs@v.invalid> - 2018-05-04 21:42 -0400
              Re: Check how date is entered dpb <none@none.net> - 2018-05-04 23:46 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-05 04:21 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-05 07:21 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-05 09:50 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-05 09:05 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-05 10:33 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-05 10:57 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-05 20:51 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-05 11:32 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-05 21:19 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-06 07:46 -0500
                Re: Check how date is entered dpb <none@none.net> - 2018-05-06 09:37 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-06 20:37 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-06 19:53 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-06 21:03 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-07 00:06 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-07 03:14 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-07 07:45 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-07 13:06 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-07 13:53 -0500
                Re: Check how date is entered malone <malone@nospam.net.nz> - 2018-05-08 08:19 +1200
                Re: Check how date is entered dpb <none@none.net> - 2018-05-07 15:35 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-07 17:38 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-07 17:26 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 00:19 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-08 01:31 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 07:45 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-08 09:45 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 14:34 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-08 14:09 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 17:06 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-08 13:48 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 15:02 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-08 14:59 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 17:04 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-08 18:53 -0500
                Re: Check how date is entered dpb <none@none.net> - 2018-05-08 21:12 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 23:51 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-09 07:20 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-09 11:32 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-09 11:35 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-09 15:03 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-09 15:18 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-07 13:34 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-07 13:44 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-07 17:40 -0400
                Re: Check how date is entered dpb <none@none.net> - 2018-05-07 17:50 -0500
                Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 00:02 -0400
  Re: Check how date is entered jan120253@gmail.com - 2018-05-07 01:45 -0700
    Re: Check how date is entered jan120253@gmail.com - 2018-05-07 01:52 -0700
      Re: Check how date is entered dpb <none@none.net> - 2018-05-07 08:16 -0500
        Re: Check how date is entered GS <gs@v.invalid> - 2018-05-07 13:10 -0400
  Re: Check how date is entered Ramon-México <cesaramon@gmail.com> - 2018-05-07 22:03 -0700

csiph-web