If I understand you right, you have a cell with a formula that reads from another cell, something like: =BlahBlah(A1)
And in this case, when A1 is empty, the cell shows $0.00 and you would prefer it showing nothing? In that case there are a few options: Tools → Options… → OpenOffice.org Calc → View → Display → Uncheck "Zero values". However, maybe you want zero values to be displayed for some cells, and not for other cells, right? Then keep "Zero values" checked and do the following instead, for every cell that you don't want to show zero values when another cell, in this example A1, is empty: Then just replace your formula (let's use the above fake example) to: =IF(A1="";"";BlahBlah(A1)) It's so simple to add too, just press (again, using the silly fake example above): *[F2] [HOME] [→]* IF(A1="";"";* [END]* ) That's as far as I can get with no details about what you are trying to do. Johnny Andersson 2007/4/11, Dan Cox <[EMAIL PROTECTED]>:
Here's one that I am sure will get plenty of replies: I am setting up a spread sheet to calculate payments, balance owed, etc, and I have 25 rows that can have data input (just to keep it all on one sheet). How do I keep the calculating formula, but make the cells stay blank (not show $0.00) if I do not put name or some other identifier into that row. In other words, how do I get only the rows that need to have calculated to show calculations, and have the remainder stay blank, but still ready to accept data. I do not want to hide the rows, because I am not the one who will use this spreadsheet, and that has already caused me messes in the past. Thank you in advance for the replies. Dan Sincerely, Dan Cox, CEO
