Date Formatting

[Max]

.. It worked fine in my tests.
And it worked fine for me over here, too <g>

Big Rick:

With Bob's sub implemented properly,
Select and *pre-format* the designated input range: H1:H10
as Custom: dddd dd mmmm yyyy

Then test by inputting some dates within H1:H10
When you press ENTER to commit each input,
Bob's code will return exactly what you're after

(My guess is you either didn't pre-format H1:H10 beforehand, or you might
have tried out the inputs elsewhere .. in A1, A2?? [I dunno]. But don't ask
me why Bob prefers "H1:H10" instead of "A1:A10" as the assumed source input
range <g>)

 

[Max]

A little "OT", sorry ..

Am trying out Dave's suggestion, but think I've forgotten
how to activate/deactivate the numeric keypad on a laptop

Thanks ..

 

[Max]

.. I did get Rogers code to work, I couldn't with Bobs',

Big Rick (as posted in the other branch),

With Bob's sub implemented properly,

Select and *pre-format* the designated input range: H1:H10
as Custom: dddd dd mmmm yyyy

Then test by inputting some dates within H1:H10

When you press ENTER to commit each input,
Bob's code will return exactly what you're after

(My guess is you either didn't pre-format H1:H10 beforehand, or you might
have tried out the inputs elsewhere .. in A1, A2?? [I dunno]. But don't ask
me why Bob prefers "H1:H10" instead of "A1:A10" as the assumed source input
range <g>)

 

[Roger Govier]

Hi Max

You should have a button marked Fn and the word Numlock in coloured type
at the base of a key somewhere.
Press both, and it should activate M as 0, JKL as 123, UIO as 456 with
the number keys 789 being 789.

 

[Ragdyer]

My Dell has small colored numbers on the letter keys, matching Roger's
scenario, where all that's necessary is to hold the Fn key (right of the
left Ctrl key) and the <Alt> key, and then use those colored numbers.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

Hi Max

You should have a button marked Fn and the word Numlock in coloured type
at the base of a key somewhere.
Press both, and it should activate M as 0, JKL as 123, UIO as 456 with
the number keys 789 being 789.

 

[Max]

Thanks, Roger & RD ! With your help, think I got it <g>.

For my m/c (IBM), I had to press Shift + ScrLk to toggle
(the tiny "Numlk" appears above "ScrLk" in white)

And the numeric* keypad numbers appear in white too (no color),
albeit in "subscript" form.

*as explained in Roger's response:

.. M as 0, JKL as 123, UIO as 456 with

Cheers

 

[Bob Phillips]

(My guess is you either didn't pre-format H1:H10 beforehand, or you might
have tried out the inputs elsewhere .. in A1, A2?? [I dunno]. But don't ask
me why Bob prefers "H1:H10" instead of "A1:A10" as the assumed source input
range <g>)

A1:A10 is boring <vbg>

 

[Bob Phillips]

In that case, why would you want the wrap-around?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Bob Phillips]

Hi Roger,

I look forward to that.

Tanglefoot, Wadworths 6X, topped off with a decent pint of Director's if we
can find it. We also have a local Ringwood micro-brewery which does a nice
ale.

Bob

 

[Roger Govier]

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 Bob<vbg>).
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

In that case, why would you want the wrap-around?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Bob Phillips]

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)

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 Bob<vbg>).
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.

 

[Dave Peterson]

No other reason than "just because".

Actually, I like this format much better:
dddd* mm/dd/yyyy

But that's just my opinion.

In that case, why would you want the wrap-around?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Bob Phillips]

Actually, I like this format much better:
dddd* mm/dd/yyyy

So do I.

 

[Guest]

I did finally get Bob' code to work by pre formatting the cells. As you can
see from the previous post, I was trying to input the date into cell H1.
Thanks for the suggestions as to why it didnt work. Many thanks to Bob also.

Many Regards
--
Big Rick

.. I did get Rogers code to work, I couldn't with Bobs',

Big Rick (as posted in the other branch),

With Bob's sub implemented properly,

Select and *pre-format* the designated input range: H1:H10
as Custom: dddd dd mmmm yyyy

Then test by inputting some dates within H1:H10

When you press ENTER to commit each input,
Bob's code will return exactly what you're after

(My guess is you either didn't pre-format H1:H10 beforehand, or you might
have tried out the inputs elsewhere .. in A1, A2?? [I dunno]. But don't ask
me why Bob prefers "H1:H10" instead of "A1:A10" as the assumed source input
range <g>)

 

[Max]

Glad to hear you got it to work!
And thanks for posting back

As you can see from the previous post,
I was trying to input the date into cell H1 ...

Yes, you did. Overlooked this earlier, apologies

---