Find a "date" in a column of dates in Excel 2000
Hi,
Just format your date column as 3/14/1998 with the full year shown. Then
the FIND should select the date you enter.
CHORDially,
Art Farrell
"JR Hester" wrote in message
...
I wnat to use the find tool to immediately goto to a specific date in a
column.
Is my determination correct that this only works with text or numbers and
not with dates.
I have sequential dates in every 20th cell in column A, with the
interveneing cells blank.
When I use the Find tool with the entire column selected, I receive teh
nioce little dialog box expalining that Microsoft Excell cannot find the
data
searched for.
Just looking for a quick way to loacte a specific date in approximately
800
rows of data, any recommendations?
|