show empty cells for zero values

cdiesxm · Newbie Joined: 11 Dec 2006 Posts: 2

Hi,

I made the move from Excel, but just one thing now is different. It prints all my spreadsheets with zero value cells as 0.00. (they are in currency)

Excel did not display zero value cells. Now I have converted them all and removed Office software. What to do?

Thank you.

Villeroy · Posted: Mon Dec 11, 2006 9:56 am Post subject:

Just like Excel: Menu:Tools>Options>Calc>View:"Show zeroes"
It is a per-document-setting, so you may want to set up a customized default template.
Shift+F11, name it and save
File>Templates>Organize...
Pick your template
Button:"Command">Set Default
Now your template will be used whenever you hit Ctr+N in Calc or call File>New>Spreadsheet.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

cdiesxm · Newbie Joined: 11 Dec 2006 Posts: 2

Thanks for your help. I tried that but it must have something to do with the import from xls.

I already had display zero unchecked but it still displayed 0.00.

However when I create template and do Ctrl-N the new template does not display zeros.
But I selected and pasted the entire spreadsheet into the newly created template and if I enter 0 in a cell it does not display, but when I Cntrl-A and paste into the blank spreadsheet it still displays zeros.

Any other ideas please?

THanks

Villeroy · Posted: Mon Dec 11, 2006 5:38 pm Post subject:

If A1 shows 0.00 check out if it is a number or text.
Some options:
=ISNUMBER(A1)
=ISTEXT(A1)
=TYPE(A1) [1=number, 2=text]
=COUNTA(A1:A1000)-COUNT(A1:A1000) [returns the count difference between all cells having content and numeric cells]
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org