cells - Excel - leave blank if value is 0 but not if value is 0.03 -
i'm leaving cells blank if value 0 using following custom format ""#,###;;;@," works great how change values "0.03" not left blank shown 0?
i tried several variations had no luck. suggestions?
solution
#,##0;;;@
if caught need solution:
general;;;@
Comments
Post a Comment