View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MDP420 MDP420 is offline
external usenet poster
 
Posts: 1
Default 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