I am using Ubuntu 22.04 and LibreOffice Version: 24.2.6.2 (X86_64) / LibreOffice Community
Build ID: ef66aa7e36a1bb8e65bfbc63aba53045a14d0871
CPU threads: 20; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: en-IN (en_IN); UI: en-US
Calc: threaded
I have formatted Cells with Format Code [>0]#,##0;<0;- so that the value of 0 (zero) will shown as – (dash). My problem is when I select multiple cells, go to find and replace, keep find as blank and replace it by 0. All the blank cells are show as zero and not dash. To remove the apostrophe with the zero, I again have to find ^. and replace it with & with regular expression enabled. Is their any easier way to do this. (avoid the last step)