Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date search problem

    I had excel 2003 and now have 2010, when I search for a date 04/05/1982 excel 2010 will not find it that way. Now I have to type 4/5/1982-I have changed the date to custom mm/dd/yyyy and that does not work. I'm old and use to typing 04/05/1982 please help

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    How are you searching? Are the dates actual dates or text? are they formatted correctly? If the format is mm/dd/yyyy and 4/5/1982 does not display as 04/05/1982 then it is not being entered as a date. Could you attach a file demonstrating the problem?

    Steve

  3. #3
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,629
    Thanks
    114
    Thanked 644 Times in 588 Posts
    buckshot,

    As a workaround, try changing your find parameters by opening the Find Dialogue box> Options> Change Look in: from formulas to Values. Your search using 04/05/1982 will find the results. Once set, you do not have to reset it.

    HTH,
    Maud

    find.png
    Last edited by RetiredGeek; 2014-03-25 at 17:12.

Posting Permissions

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