Ask a question about EXCEL replace the function?

Users questions:I want to EXCEL in the show as the # DIV * 0! Replace all the cells into a 0, how should get? Is because the formula is not illegal it will appear # DIV * 0!, Do not know if EXCEL there is no such function?
Experts answer: * replace the time-point search options - ranging from search"Formula" to "value", and then search for "# DIV * 0!" Can be found. Random replace it:)
  • This information provided by the users.Thanks!