Results 1 to 6 of 6
  1. #1


    Member Since
    Nov 08, 2013
    Posts
    3
    Find feature in Excel not working
    can not locate an item (7/1/12) in an Excel worksheet in order to replace it with another date. (Office for Mac 2011)

  2. #2

    Joncon's Avatar
    Member Since
    Nov 05, 2013
    Posts
    24
    Are you using command-f to open the find feature?

    Try searching for 07/01/2012.

    I have the same office version that you have and that is the way it formats dates.
    MacBook Pro 13" 2.5GHz i5 / iPhone 5 16GB

  3. #3


    Member Since
    Nov 08, 2013
    Posts
    3
    Thanks for your response. I opened the Find feature with the Edit drop down menu. Am trying to update an old Excel worksheet that has dates entered as 7/1/12, and change them all to 1/1/2014. Tried entering 07/01/2012 in the find menu but it could not be located. Any other suggestions?

  4. #4


    Member Since
    Nov 09, 2011
    Posts
    252
    Specs:
    15" rMBP Mid-2014 ~ iPad 4 16GB ~ iPhone 6 Plus 16GB
    Click on one of the 7/1/12 cells and look at the formula edit (name?). Use what you see in there as your search text.

    I formatted my cells to have 'm/d/yy' to match American date format, see Cell A1 in my attachment. However, the "formula edit" shows '2012/07/01'.

    Searching for 2012/07/01 results in a hit. In your case, the "formula edit" will likely show a different format, but use whatever you see there in your search.
    Attached Images Attached Images

  5. #5


    Member Since
    Nov 08, 2013
    Posts
    3
    Checco: Many thanks! That solved my problem. Your responses are very much appreciated.

  6. #6


    Member Since
    Nov 09, 2011
    Posts
    252
    Specs:
    15" rMBP Mid-2014 ~ iPad 4 16GB ~ iPhone 6 Plus 16GB
    Glad to help!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Safari Find Feature Gone
    By CastorTroy in forum OS X - Operating System
    Replies: 9
    Last Post: 01-14-2013, 11:00 PM
  2. Zip file/compression feature not working properly
    By sabbajay in forum OS X - Operating System
    Replies: 1
    Last Post: 10-03-2012, 06:45 AM
  3. Hotmail Slideshow feature not working
    By Randakk in forum OS X - Apps and Games
    Replies: 3
    Last Post: 03-02-2012, 01:48 PM
  4. So finally Find My Mac feature is now live for developers
    By i0xSian in forum OS X - Operating System
    Replies: 1
    Last Post: 08-05-2011, 02:01 AM
  5. Excel Mac 2008 - AutoComplete feature
    By tiger roach in forum OS X - Apps and Games
    Replies: 5
    Last Post: 05-21-2009, 07:12 PM

Posting Permissions

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