Ask Your Question

I want to replace zero with blank

asked 2018-10-08 13:25:48 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I have a checkbook spread sheet. I would like for the cells to display blank instead of $0.00

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-10-08 14:24:59 +0100

erAck gravatar image

updated 2018-10-08 14:25:31 +0100

Use number format code [$$-409]#,##0.00;[RED]-[$$-409]#,##0.00; (or similar, corresponding to your locale's currency and display format, note the trailing semicolon that denotes an empty display string for 0) which is an equivalent of [>0][$$-409]#,##0.00;[<0][RED]-[$$-409]#,##0.00;"" and in fact after saving to .ods and reloading becomes such.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-10-08 13:25:48 +0100

Seen: 102 times

Last updated: Oct 08 '18