Finding cells with a value ending in '.0'
Hi
I have a spreadsheet with a series of values (140.0, 140.2 etc) and I want
to locate and isolate all cells ending in '.0'
When I search for cells with this value using CTRL F however, it doesn't
recognise .0 or *.0 or ?.0
Just wanted to know if there's a quick way of doing this otherwise it's
going to be a long manual job!!
Thanks
|