+ Reply to Thread
Results 1 to 3 of 3

"Please enter a date in the format dd/mm/yyyy" error

  1. 08-18-2015, 10:59 AM #1
    marcelotero
    marcelotero is offline
    Registered User
    Join Date
    08-18-2015
    Location
    ireland
    MS-Off Ver
    Excel 2007 12.0.6550.5004 SP2 MSO 12.0.6554.5001
    Posts
    1

    "Please enter a date in the format dd/mm/yyyy" error

    Hi all folks,

    I'm new here.
    I have a problem with a file, there are some fields formatted as "general", but when trying to enter a value I got the message error "Please enter a date in the format dd/mm/yyyy". I've tried to change format type and reset again, but nothing.

    Any idea what could it be?
    If any other info needed let me know

    The sheet is protected but the field I'm talking about are not.

    thank you in advance!
    Mattia
    Reply With QuoteRegister To Reply
  2. 08-18-2015, 11:07 AM #2
    Special-K
    Special-K is offline
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: "Please enter a date in the format dd/mm/yyyy" error

    Maybe here?

    https://support.office.com/en-nz/art...2-95b6aeeb73c9
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
    Reply With QuoteRegister To Reply
  3. 08-18-2015, 12:23 PM #3
    ChemistB
    ChemistB is offline
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: "Please enter a date in the format dd/mm/yyyy" error

    I agree with Special K, select the cell and check "Data Validation" (on the Data Tab). The spreadsheet designer set up criteria on those cells.
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
    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)

Similar Threads

  1. [SOLVED] VBA Get the Date Format Change As "MM-DD-YYYY" In Range
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-20-2014, 10:37 AM
  2. need macro to filter only the date which has the format "mm/dd/yyyy" and not text date
    By 1Anil in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-11-2013, 10:35 AM
  3. [SOLVED] Convert from "general" (YYYYMMDD) to specific "custom" format (YYYY.MM.DD)
    By Ella_p in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-10-2013, 02:23 AM
  4. Macro-Highlight cells in column D if the date format is other than "mmm-dd-yyyy hh:mm:ss"
    By mani88 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2013, 06:25 AM
  5. [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
  6. VBA - Save AS, filename from cell as date in format "YYYY-MM-DD"
    By lukestkd in forum Excel General
    Replies: 0
    Last Post: 08-09-2012, 04:31 PM
  7. convert string to date format of "d-mmm-yyyy"
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-12-2011, 09:48 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1