Delete single zero in cell

[rosef]

I accidently inserted single zeros in a bunch of cells. How do I delete them? Find and replace?

[Paul]

Hi Rosef,

You can click the Undo button until the zeros are un-done. If that's not an option, you can use the Replace dialog, however be sure to click the "Options >>" button and check the box for "Match entire cell contents". Otherwise, it will replace all zeros in your spreadsheet, including those in text and part of other numbers.

Also note, that this will remove all zeros that are meant to be there. If there shouldn't be any zeros, then you won't have any issues.