Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Entering dates for computation purposes

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    1. When I enter ="1/1/1995" on a NEW worksheet,I get a numerical answer as expected.
    2. When I enter the same info on an EXISTING
    worksheet,I get the date and cannot get EXCEL to recognize it as a number.
    3. How can I correct this situation?

    Thanks ... Al Nasitano

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    Probably you have the cells formatted as Text, use any date format.

    Or you can easily convert by copying a number 0 from any cell, selecting the dates and going to Edit>Paste Special | Add then format as dates

  3. #3
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try it without the quotation marks.

    Hope this helps.
    Kind regards, Al.

  4. #4
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Good point!


    alonzo3, are you sure you were getting a real number on a new worksheet using

    ="1/1/1995"

    ???

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-15 07:34, alonzo3 wrote:
    1. When I enter ="1/1/1995" on a NEW worksheet,I get a numerical answer as expected.
    2. When I enter the same info on an EXISTING
    worksheet,I get the date and cannot get EXCEL to recognize it as a number.
    3. How can I correct this situation?

    Thanks ... Al Nasitano
    Enter ="1/1/1995"+0 instead.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •