+ Reply to Thread
Results 1 to 3 of 3

How to change date format?

  1. 04-30-2010, 10:26 AM #1
    ncaravela is offline
    Forum Contributor
    Join Date
    04-27-2010
    Location
    Lisbon, Portugal
    MS-Off Ver
    Excel 2007
    Posts
    115

    How to change date format?

    Hi,

    I'm using a date txtbox in a userform but it appears like this: 4/30/2010. A wanted it to appear like this: 30/04/2010.

    I'm using this code
    Please Login or Register  to view this content.
    Can anyone help me finish the code?

    Thanks
    Reply With QuoteRegister To Reply
  2. 04-30-2010, 11:03 AM #2
    davegugg is offline
    Forum Expert davegugg's Avatar
    Join Date
    12-18-2008
    Location
    WI, US
    MS-Off Ver
    2010
    Posts
    1,884

    Re: How to change date format?

    Should be:

    Please Login or Register  to view this content.
    Is your code running too slowly?
    Does your workbook or database have a bunch of duplicate pieces of data?
    Have a look at this article to learn the best ways to set up your projects.
    It will save both time and effort in the long run!


    Dave
    Reply With QuoteRegister To Reply
  3. 04-30-2010, 11:03 AM #3
    MarMo is offline
    Forum Contributor
    Join Date
    09-21-2009
    Location
    Belgium - Mechelen
    MS-Off Ver
    Office 365 - version 2310
    Posts
    278

    Re: How to change date format?

    you could use : 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1