Am 16.09.2007 um 20:39 schrieb Michael J. Vinca: Are your values considered dates to Excel? For example, when you search on "2007" does Gefunden have values such as date "Tuesday, November 28, 2006 12:00:00 AM"? If so, ".06" won't work. You will need to search for "June" instead. Unfortunately, Excel throws an error if the find doesn't find anything, so you have to use a try instead of just expecting "nothing" as the documentation states.
@ Michael J. Vinca: Thanks for your quick answer and the hint with the try command.
Yes, when I search for "2007" I will get "date "Freitag, 2. Februar 2007 0:00:00 Uhr". When the cells are formatted as date without text like "19.05.2007" I can't search for a month name, nor for "." or numbers with leading zeros like "02". Only when the cells in Excel are formatted as date with "text elements" like June, July etc, I can search for them.
Maybe there is a preference to change in Excel. Or is there a possibility to change the date format in Excel from "23.03.2007" to "March 23, 2007" before performing a search? Something with the "style"- command?
Thanks, Andreas
|