| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to format cells to show dates as the week-ending date of that | Excel Worksheet Functions | |||
| Finding Cells | Excel Worksheet Functions | |||
| Finding days between cells C and L where the cells may be empty | Excel Worksheet Functions | |||
| Ending zero | Excel Discussion (Misc queries) | |||
| Subtract a group of cells from a total based on ending date | Excel Discussion (Misc queries) | |||
Threaded Mode
