Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   How to convert numbers to date in excel (https://www.askmehelpdesk.com/showthread.php?t=449303)

  • Feb 20, 2010, 05:15 AM
    amanneol
    How to convert numbers to date in excel
    As I am entering the date format dd/m/yyyy. The output is coming in the form of a number.
    For example.. as I am inputting the date as 10/8/2008, the output that I am getting is 39729. Can you please help me out in this?
  • Feb 20, 2010, 05:17 AM
    amanneol

    As I am inputting the date in the format of dd/m/yyyy. The output that I am getting is a number. Like I am inputting 10/8/2008, the output that I am receiving is 39729. Help me in getting the date that I want to input
  • Feb 20, 2010, 11:31 AM
    JBeaucaire

    The numeric conversion is automatic and required for Excel to be able to properly deal with DATE strings. The problem is that you're SEEING the conversion, it should not be evident.

    1) Highlight the cell(s) in question
    2) Press CTRL-1 to open the Format Cell window
    3) Under Category: select Date
    4) Under Type: choose the date format you want to display, there are many

    • All times are GMT -7. The time now is 05:01 AM.