| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
BLANK cell TO A NUMBER
I want to replace all the cells that have no text or number in them to the
number Zero. What do I do? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
BLANK cell TO A NUMBER
Select your range to fix (including the filled in cells)
edit|goto|special|Click Blanks|ok (notice that only the blank cells in that original range are selected) type 0 hit ctrl-enter (instead of enter) to fill those empty cells. kevin wrote: I want to replace all the cells that have no text or number in them to the number Zero. What do I do? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select cell based on a number in another cell | New Users to Excel | |||
| Return of blank cell if lookup fails | Excel Worksheet Functions | |||
| how to count the number of text frequencies and copy to other cell | Excel Worksheet Functions | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
Hybrid Mode
