leave cells blank when zeros

Hi all,

First post for me here, hopefully I will get some help.

I have a spreadsheet that I use as a template to invoice my customers.

Pretty basic stuff, but I would like to add a macro in a button so when I click on it all the cells containing “0” (zero) are left blank.

Would anyone be happy to help me out?

Thank you very much.

See number format codes with 3 sections:
https://help.libreoffice.org/latest/en-US/text/shared/01/05020301.html

Maybe, but I will not write a macro for this.

Zero values
cause AI says …