Results 1 to 7 of 7

Current year in cell not 1900!!

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-23-2007
    Location
    Texas
    Posts
    417

    Current year in cell not 1900!!

    I've conditioned formated some cells so that someone can type a number in and a date will appear in the cell.

    Problem is if someone types 20 in the cell.. excel reverts back to Jan-20-1900

    How can I get the current month and year when a number is typed in the cell?

    Did excel exsist in the 1900?

    SOLVED
    Solution - I used the if command in A2 like this
    =if(a1="",0,2009)
    This was kind of a noob way of doing it but hey... I'm not real smart..
    Last edited by Tortus; 01-16-2009 at 12:32 AM.

Thread Information

Users Browsing this Thread

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

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