In the Find and Replace function of MS Word you have the option to find whole words only. Is it possible to replicate this within Excel - I am aware that you can match exact cells but that will not suffice.

I need to change all values within a spreadsheet which are 0.1 (exactly) to 0.01. The only solution I can find also changes values such as 0.108 to 0.0108 which I don't need.

Any ideas?

Thanks

Andi