Results 1 to 25 of 25

Check Date Format Input into Excel Column with VBA code ("DD/MM/YYYY" format)

Threaded View

inoka Check Date Format Input into... 12-11-2017, 04:11 AM
ranman256 Re: Check Date Format Input... 12-11-2017, 10:08 AM
inoka Re: Check Date Format Input... 12-11-2017, 11:40 PM
inoka Re: Check Date Format Input... 12-11-2017, 11:48 PM
inoka Re: Check Date Format Input... 12-12-2017, 01:31 AM
ikboy Re: Check Date Format Input... 12-12-2017, 04:11 AM
inoka Re: Check Date Format Input... 12-12-2017, 04:30 AM
jindon Re: Check Date Format Input... 12-12-2017, 06:31 AM
inoka Re: Check Date Format Input... 12-12-2017, 08:07 AM
jindon Re: Check Date Format Input... 12-12-2017, 08:14 AM
inoka Re: Check Date Format Input... 12-12-2017, 11:17 PM
jindon Re: Check Date Format Input... 12-12-2017, 11:20 PM
inoka Re: Check Date Format Input... 12-13-2017, 07:28 AM
inoka Re: Check Date Format Input... 12-13-2017, 07:43 AM
jindon Re: Check Date Format Input... 12-13-2017, 07:48 AM
inoka Re: Check Date Format Input... 12-14-2017, 12:42 AM
jindon Re: Check Date Format Input... 12-14-2017, 12:54 AM
inoka Re: Check Date Format Input... 12-14-2017, 02:54 AM
jindon Re: Check Date Format Input... 12-14-2017, 03:15 AM
inoka Re: Check Date Format Input... 12-14-2017, 04:20 AM
jindon Re: Check Date Format Input... 12-14-2017, 04:29 AM
inoka Re: Check Date Format Input... 12-14-2017, 07:42 AM
jindon Re: Check Date Format Input... 12-14-2017, 08:30 AM
jindon Re: Check Date Format Input... 12-14-2017, 07:58 AM
inoka Re: Check Date Format Input... 12-14-2017, 08:26 AM
  1. #22
    Forum Contributor
    Join Date
    12-11-2017
    Location
    Colombo
    MS-Off Ver
    2013
    Posts
    109

    Re: Check Date Format Input into Excel Column with VBA code ("DD/MM/YYYY" format)

    There's a some issue. When I enter data value with "0", automatically, it is discarded initial "0" value. Then, it is shown as one digit number and it is displayed as error.

    Ex: when I add date as 04/06/2018, automatically excel converts it into 4/6/2018 and it is shown as invalid data.
    When I add date as 23/04/2019, automatically excel converts it into 23/4/2019 and it is shown as invalid data.

    Everything is working properly, how do I avoid this automatic conversion.
    Last edited by inoka; 12-14-2017 at 07:50 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Check Date Format Input into Excel Column with VBA code
    By stanlelma in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 01-20-2024, 03:27 AM
  2. [SOLVED] Text box validation - date entry - format "dd mm yyyy"
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-25-2017, 09:01 AM
  3. [SOLVED] Userform Dynamically Generated Combobox format value as date ("mm/dd/yyyy")
    By CieloSalas in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-12-2017, 03:39 PM
  4. Replies: 8
    Last Post: 06-21-2016, 08:56 AM
  5. Replies: 3
    Last Post: 08-13-2013, 06:25 AM
  6. [SOLVED] Format a column as date format "yyyy-mm-dd"
    By Seraph122 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-11-2013, 01:30 AM
  7. Replies: 1
    Last Post: 11-01-2012, 10:37 AM

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