Page 1 of 1

replacing null and zero values

PostPosted: Fri Dec 21, 2007 5:31 pm
by grooveman

I have been trying for some time now to reformat all zeros and null values to a "-" character.

What I mean by "null" is either a cell that is emtpy, or when a formula or equation returns a nonsensical value, such as: "#DIV/0!", "#VALUE!" or some such similar thing.

I don't want to see those big, ugly errors all over my spreadsheet, I would prefer to simply see a "-". How is this accomplished?

Thank you!


Re: replacing null and zero values

PostPosted: Sat Dec 22, 2007 3:39 am
by TerryE
In Calc you also see the Err:XXX codes. In calc a cell has its contents, which may be a formula which itself my return a value. You then have the formatted value that are displayed within the controller view -- that is what you see in the GUI. You have quite a lot of control over how contents are formatted through use of Format codes in the Format Cells options (see the online help on this topic for more details), but Errors will display as errors unless you trap them with an =IF(ISError(expr)...) check, or the equivalent Informational functions.