+ Reply to Thread
Results 1 to 6 of 6

DTPicker Formating Month to uppercase, e.g. Apr

  1. #1
    Forum Contributor
    Join Date
    05-08-2009
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    223

    DTPicker Formating Month to uppercase, e.g. Apr

    Hi

    I have tried numerous times to see if I can format the output of a DTPicker to that shown below, i.e. using the current date as an example,

    17APR13

    However so far all suggestions have failed...

    Does anyone know if the output, intending to be inserted into a bookmark, can be changed prior to the data being passed over into the bookmark?

    Using the ActiveX v.6 DTPicker

  2. #2
    Forum Contributor
    Join Date
    05-08-2009
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    223

    Re: DTPicker Formating Month to uppercase, e.g. Apr

    If not can anyone suggest a workaround?

  3. #3
    Forum Contributor
    Join Date
    05-08-2009
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    223

    Re: DTPicker Formating Month to uppercase, e.g. Apr

    Anyone......?

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: DTPicker Formating Month to uppercase, e.g. Apr

    Can't you just use this?
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  5. #5
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,169

    Re: DTPicker Formating Month to uppercase, e.g. Apr

    Hi Andy,

    See if this helps.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  6. #6
    Forum Contributor
    Join Date
    05-08-2009
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    223

    Re: DTPicker Formating Month to uppercase, e.g. Apr

    Thanks peeps...it's easy when you know how :P

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1