Excel not recognizing date input

Posted on 2012-09-18
Last Modified: 2012-09-18
Dear Sir,

When I input the date in Excel like 20120919 without "/" and "-", the date is not recognized.

Is there any method can solve it?

Question by:Wataw
    LVL 23

    Expert Comment

    You could format the cells as customer format "yyyymmdd" and then enter the date like 19/09/2012 and excel will display it in the correct format

    LVL 18

    Accepted Solution

    Custom format the cell as 0000-00-00

    or use



    Author Comment

    Dear Kris,

    Thanks. It's works. I can input the date without enter the "/" or "-" now.

    With regards,

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Detect file exist or not 3 42
    Excel sending an email 5 40
    Search Box 13 30
    add a password to open excel after 60 days 8 27
    I've recently been in need of an Excel macro that could add a letter before the text on multiple cells in an Excel document. My English is as it is, so I will try explain what it does diffrently. If you have an excel document with 2000 rows an…
    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now