 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2007find/replace
I'm trying to find all the 0's in a certain column and replace them with a blank. However, when I hit the "find next" it finds a number that's not 0. For example, it'll find the number 126.423 which doesn't even have a 0 in it at all. I don't what the problem is. LLama Is 126.423 the result of a formula? If you select the cell that contains 126.423, what does the Formula bar display? George Gee > I'm trying to find all the 0's in a certain column and replace them > with a blank. However, when I hit the "find next" it finds a number > that's not 0. For example, it'll find the number 126.423 which > doesn't even have a 0 in it at all. I don't what the problem is. Hi In the Find and Replace dialogue, click Options and tick Match entire cell contents.  SignatureRegards Roger Govier > I'm trying to find all the 0's in a certain column and replace them > with a blank. However, when I hit the "find next" it finds a number > that's not 0. For example, it'll find the number 126.423 which > doesn't even have a 0 in it at all. I don't what the problem is.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.