LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 505
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to find what number in Column A is not included in Column B? Zhi Sheng Excel Discussion (Misc queries) 2 September 1st 08 02:42 AM
Find max Row() number for a value in column Vlado Sveda Excel Worksheet Functions 12 January 20th 07 05:32 PM
Despite data existing in Excel 2002 spreadsheet Find doesn't find AnnieB Excel Discussion (Misc queries) 1 June 16th 06 02:15 AM
how do i find the lowest number in a column in Excel? MKA808 Excel Discussion (Misc queries) 4 August 23rd 05 07:27 PM
How do I find the first value in a column less than a number? redeucer Excel Worksheet Functions 6 November 4th 04 09:59 PM


All times are GMT +1. The time now is 11:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"