Ask Your Question

how to fill empty cells with zeros?

asked 2019-04-03 11:20:41 +0200

OfficeLibre2 gravatar image

updated 2020-08-07 22:05:25 +0200

Alex Kemp gravatar image

I'd like to fill all empty cells in my table with 0. I tried "find and change" ("znajdź i zamień" in Polish, Ctrl+H) function, where "find" field was empty and "change" contained 0. However, after running, empty cells were filled with 0, but it was aligned to the left side of each cell (instead of numbers which are aligned to the right). When I clicked on some of these cells, instead of 0 they contained '0 and it was impossible to correct it with "find and change". How can I do it correctly?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-04-03 12:36:57 +0200

erAck gravatar image

That a text 0 was entered instead of numeric 0 (apparently happens only if the replacement is on an empty cell) looks like a bug. If you'd care to submit one at ?

However, the leading ' apostrophe is not part of the cell content (hence can't be searched for) but indicates the content could be interpreted as numeric if reentered. You can change the result by selecting the cell area in question and invoke Ctrl+H again and

  • Find: ^0$
  • Replace: 0
  • under Other options:

    • tick Current selection only
    • tick Regular expressions
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-04-03 11:20:41 +0200

Seen: 1,981 times

Last updated: Apr 03 '19