Re: Date Formatting

Tech-Archive recommends: Fix windows errors by optimizing your registry

> .. 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>)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--


.

Relevant Pages

  • Word Wrap on a button
    ... I have made a custom button and when I place text in it, ... END SUB ... Chuck ... Prev by Date: ...
    (microsoft.public.dotnet.framework.drawing)
  • Re: How do i copy a template form and put it in my database?
    ... I did that and it says "Sub not defined" and this is actually a report not a ... "Rick B" wrote: ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Re: Run cmd button in code
    ... > above (the part about it not being a Sub that is). ... That garbled part should read "Please read the second word that you see and ... Rick ... Prev by Date: ...
    (microsoft.public.vb.general.discussion)
  • Re: Ever had to judge a new to-be-hired in interview?
    ... > Sub Command1_Click ... Create a different one-liner equivalent to this statement ... Rick ... Prev by Date: ...
    (microsoft.public.vb.general.discussion)
  • Callthis
    ... I am using the dependson('one of my custom props')+callthis('my sub') for one ... of my some of my shapes. ... Prev by Date: ...
    (microsoft.public.visio.developer)