In excel when you do an <Edit <Find the default is find in a formula. If
you do not remember to change to value, it will never find text or numberics
that are actually there. Does anyone know if you can change the default to
find "values" or text?

Thanks for the help.
Nino

It will still find values, try it

put abc in A1, in A2 put ="abc"
in A3 put abc

do editfind and use abc, then just click find next


Regards,

Peo Sjoblom

"Nino Richards" wrote:

In excel when you do an <Edit <Find the default is find in a formula. If
you do not remember to change to value, it will never find text or numberics
that are actually there. Does anyone know if you can change the default to
find "values" or text?

Thanks for the help.
Nino