Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FIND and dates
I have several large spreadsheets in 2007, each containing many columns of
numbers, dates, and text. When I hit CTRL F and type either a number or text in the box, it's found immediately. When I try dates, "...cannot find the data..." pops up. Date is currently formatted as 30-Jun-08. What do I need to do to make dates able to be found (short of changing the date presentation on the sheet)? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find the three nearest dates | Excel Worksheet Functions | |||
find dates between in excel | Excel Discussion (Misc queries) | |||
Find future dates | Excel Discussion (Misc queries) | |||
How do I find the earliest dates in a range of dates? | Excel Worksheet Functions | |||
How to find if a date falls between 2 dates | Excel Worksheet Functions |