Changing a default setting in "Find"

[brmaa51]

When I use "Find" to search for a certain dollar amount in a spreadsheet, and I know that what I'm searching for is in that spreadsheet, it won't find that dollar amount. In the options box, the default setting is "Formulas" and I have to change it to "Values". Is there a way to make the default setting "Values"?

 

[Fluff]

Not that I'm aware of, without the use of VBA, but once you have changed to "Values" it will remember that until, either you change it, or you close Xl