View Single Post
  #2   Report Post  
Art Farrell
 
Posts: n/a
Default 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?