Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
find
One way you could achieve this is to highlight the column and then
apply conditional formatting - Format | Conditional Formatting and in the panel that pops up set the condition as Cell Content Is, Equal To, 0 (zero) then click the Format button, and select the colour as White, then OK twice. This will use a white foreground colour on a white background for cells that contain 0, which will make them appear blank. Hope this helps. Pete On Jul 10, 8:56 pm, LLama wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
find
Select the column by clicking on the letter above that column.
Then hit Ctrl-H or go to the Edit menu and select Replace (this will bring up the Find and Replace command) now put 0 in the Find box and key in a space for an actual character of space or key nothing for a null value. "LLama" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
find
Maybe I'm wrong, but I don't think that will help. Won't the number 0
still be in the cell, I just won't be able to see it? On Jul 10, 4:12 pm, Pete_UK wrote: One way you could achieve this is to highlight the column and then apply conditional formatting - Format | Conditional Formatting and in the panel that pops up set the condition as Cell Content Is, Equal To, 0 (zero) then click the Format button, and select the colour as White, then OK twice. This will use a white foreground colour on a white background for cells that contain 0, which will make them appear blank. Hope this helps. Pete On Jul 10, 8:56 pm, LLama wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
'find' somtimes can't find numbers. I folowd the 'help' instructi. | Excel Worksheet Functions | |||
How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | Excel Discussion (Misc queries) |