Can you change the defaults for Excel
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 |
All times are GMT +1. The time now is 05:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com