+ Reply to Thread
Results 1 to 14 of 14

Date Time Picker Change to Text

  1. #1
    Forum Contributor
    Join Date
    04-16-2014
    Location
    Witbank, SA
    MS-Off Ver
    Excel 2013
    Posts
    268

    Date Time Picker Change to Text

    Hi,

    I am using the Excel DATE TIME PICKER. It works great but I have a teeny problem with the date format. The date displays like this: 01/01/2014. I am trying to convert the Date format to appear like this: 01-Apr. I have also noticed that the date format hasn't got a text element to it, so it can't be converted to text...unless someone can show me how. I appreciate your time on this one..

  2. #2
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Date Time Picker Change to Text

    Hi,

    - Right click at the Date Time Picker control, then click Properties
    - Goto Format property and select 3 - dtpCustom
    - Goto CustomFormat property and fill with this : dd MMMM yyyy
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important

  3. #3
    Forum Contributor
    Join Date
    04-16-2014
    Location
    Witbank, SA
    MS-Off Ver
    Excel 2013
    Posts
    268

    Re: Date Time Picker Change to Text

    Hi,

    I have done what you said, but as far as I can see, there is no change. I have attached 2 printscreens, maybe you can see what I am doing wrong here. Thanx for your help..
    Attached Files Attached Files

  4. #4
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Date Time Picker Change to Text

    You must do this in sequence :
    1. Change Format property
    2. Change CustomFormat property

    After you change the Format property, please try to empty the CustomFormat (empty the property box) and then refill with dd MMMM yyyy

    Regards
    Last edited by karedog; 10-23-2014 at 06:04 AM.

  5. #5
    Forum Contributor
    Join Date
    04-16-2014
    Location
    Witbank, SA
    MS-Off Ver
    Excel 2013
    Posts
    268

    Re: Date Time Picker Change to Text

    I appreciate your efforts..but it's not working..I'm giving up.

    Thanx for trying..

  6. #6
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Date Time Picker Change to Text

    Quote Originally Posted by juriemagic View Post
    I appreciate your efforts..but it's not working..I'm giving up.

    Thanx for trying..
    It's working fine here, can you upload your file ? I will look at it.

  7. #7
    Forum Contributor
    Join Date
    04-16-2014
    Location
    Witbank, SA
    MS-Off Ver
    Excel 2013
    Posts
    268

    Re: Date Time Picker Change to Text

    The current file is 10,4 Meg, a whole lot of confidential information unfortunately. I have however created just the necessary. I still cannot get the date format to be different. Please see attached. Thank you..
    Attached Files Attached Files

  8. #8
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Date Time Picker Change to Text

    I just have looked at your file, and it's working flawlessly here, I don't change anything at all.
    I attach the screenshot of your file running on my PC.

    U.GIF

    I don't know what is wrong, but maybe your mscomctl2.ocx file is broken ?

  9. #9
    Forum Contributor
    Join Date
    04-16-2014
    Location
    Witbank, SA
    MS-Off Ver
    Excel 2013
    Posts
    268

    Re: Date Time Picker Change to Text

    A bit of a mis-understanding maybe...I'm trying to convert the dates as displayed in columns C and D. Instead of 12/11/2014, I would like 12-Nov..

  10. #10
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Date Time Picker Change to Text

    Aaah... , then it's no relation with the Date Time Picker control at all.

    You must change it via cell formatting :
    - Press Ctrl 1
    - Choose tab Number
    - Choose Custom
    - Enter this to the Type box on the right side : dd mmmm

    Regards

  11. #11
    Forum Contributor
    Join Date
    04-16-2014
    Location
    Witbank, SA
    MS-Off Ver
    Excel 2013
    Posts
    268

    Re: Date Time Picker Change to Text

    Nope..Not changing at all. Maybe I must just change everything else to work with this problem.
    Attached Files Attached Files

  12. #12
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Date Time Picker Change to Text

    Hi,

    Sorry I answer #9 without checking first. The cell pointed by LinkedCell always get a result from the control as text, not as date.
    So you must point the LinkedCell elsewhere outside your worksheet view, for example point to cell Z1, then the formula at C1 :

    Please Login or Register  to view this content.
    Regards

  13. #13
    Forum Contributor
    Join Date
    04-16-2014
    Location
    Witbank, SA
    MS-Off Ver
    Excel 2013
    Posts
    268

    Re: Date Time Picker Change to Text

    Thank you!!..finally..hahaha..

    Gosh, you have been busy with this one!!!..thanx a lot!!

  14. #14
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Date Time Picker Change to Text

    You're welcome Jurie , don't worry, busy is my middle name
    Don't forget to mark this thread as Solved.

    Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 12-08-2013, 06:11 PM
  2. [SOLVED] Time & date picker.
    By Gareth_iowc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-10-2012, 10:45 AM
  3. Date/Time Picker
    By adam2308 in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 09-06-2009, 04:26 PM
  4. [SOLVED] Format text box and move across date time picker
    By Basil in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-24-2005, 05:05 PM

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