I'm trying to use a custom number format to format a cell with a value that is rounded to zero (but not quite zero) to be blank.
The format string I'm using currently testing is #.###;-#.###;
, although that doesn't quite work (shown below with "x" used in the third block of the format string). I'd want -0.234 to be shown as blank, not as a cell containing only a minus sign.
What would be the proper way to achieve this, given that I need/want to set the number format externally (via another application)?