Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to find 0.00 in a column of number?
Hello Friends,
I have a column of numbers with repeated 0.00 as follows: A 1 250.00 22 0.00 48 360.36 62 720.65 88 0.00 102 0.00 123 650.32 145 0.00 I would like the cursor to skip from one 0.00 to the next 0.00. I tried to use the Find and Replace function by typing 0.00 as search item. However an error message told me the item was not found. When I typed in 0 only, and click next the cursor skip from one number to the next irrespective of its values. May I know how to solve this problem ? Thanks Low -- A36B58K641 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find what number in Column A is not included in Column B? | Excel Discussion (Misc queries) | |||
Find max Row() number for a value in column | Excel Worksheet Functions | |||
Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
how do i find the lowest number in a column in Excel? | Excel Discussion (Misc queries) | |||
How do I find the first value in a column less than a number? | Excel Worksheet Functions |