select the offending columns/locations/areas and format as date. (You don't
have to restrict selection to each individual cell, just don't select areas
that would be adversely affected by the formatting to date or the replace
command).

then do Edit=Replace
Replace What: \
Replace With: \
this should cause the date to be reevaluated and stored as a date.

--
Regards,
Tom Ogilvy

"Steph" wrote in message
...
Hi all. Withing a sheet, there are multiple instances of a date being
formatted as text (within a cell, '10/2004). I can use the datevalue
function to convert them. But, they occur in several spots, and their
locations vary from month to month. Is there a way to scan an entire
sheet,
find dates formatted as text (ie look for a "/"), and convert them to date
format so my lookup formulas work?