Note: The following assumes you have your cells formatted to display a
single decimal digit.

In case you didn't read my response to Harlan, or if that response was too
brief to make sense of, give this a try. Bring up the Find dialog box (using
either Edit/Find from the menu bar or pressing Ctrl+F on the keyboard). If
all the options are not showing, click the Options button. Type .0 (that
is, a dot followed by a zero) in the "Find what" field. Next, click the down
arrow on the Format button and select "Choose Format From Cell" on the
drop-down list that appears; then click any cell with your cell-formatted
value in it. Alternately, you could click the Format button, click the
Number tab and select the same cell number format you used to format the
cells initially. After you have done that, select Values in the "Look in"
drop-down back on the Find dialog box. That's it... click the "Find All"
button and you should see all your cells where the value ends with .0
displayed.

Rick


"MDP420" wrote in message
...
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