+ Reply to Thread
Results 1 to 2 of 2

find method fails to find custom format date

  1. #1
    Registered User
    Join Date
    03-19-2010
    Location
    Bulgaria
    MS-Off Ver
    Excel 2007
    Posts
    7

    find method fails to find custom format date

    hi all,
    I'm trying with no success to find (by find method) the date entered in a cell (custom formatted as "dd.mm.yy") in a range of cells (custom formatted as "d" and being formula result). Any ideas how could I do this?

  2. #2
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: find method fails to find custom format date

    the find replace function appears to only work using the default date formating mm/dd/yyyy.
    If you liked my solution, please click on the Star -- to add to my reputation

    If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.

+ Reply to Thread

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