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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to find 0.00 in a column of number?
Hi
Type 0.00 as the item to findClick on Options in the Find dialoguechoose Look in ValuesMatch entire contents -- Regards Roger Govier "Mr. Low" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to find 0.00 in a column of number?
Hi,
Thank you Roger for your help. Best Regards Low -- A36B58K641 "Roger Govier" wrote: Hi Type 0.00 as the item to findClick on Options in the Find dialoguechoose Look in ValuesMatch entire contents -- Regards Roger Govier "Mr. Low" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to find 0.00 in a column of number?
Hi,
Here is another alternative: Use the AutoFilter. - with your cursor in the data or selecting the column with the 0.00 choose Data, Filter, AutoFilter, open the auto filter drop down and choose 0.00. -- Thanks, Shane Devenshire "Mr. Low" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to find 0.00 in a column of number?
Hello Shane,
Thanks for the tip. Low -- A36B58K641 "ShaneDevenshire" wrote: Hi, Here is another alternative: Use the AutoFilter. - with your cursor in the data or selecting the column with the 0.00 choose Data, Filter, AutoFilter, open the auto filter drop down and choose 0.00. -- Thanks, Shane Devenshire "Mr. Low" wrote: 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 |
Reply |
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 |