On Tue, 2005-07-12 at 11:54 -0500, K. Shantanu wrote: > Hello, > I want to do my monthly/yearly bugdet on ooffice calc. > I have a column of figures to be added. So I went to the bottom of the > column and pressed the summation icon. I editied it to give, > =SUM(C5:C22) > and pressed ENTER. But instead of sum I see "###" What is wrong? > Why 3 hases are shown? > Thanks for the help. > Shantanu >
This is covered in the user guide on page 181, http://documentation.openoffice.org/manuals/OOo1.x.x/printed.html , Which says as Follows: "When a number cannot be displayed in a cell because it is too long, or due to the formatting, e.g., currency format,###” is displayed. In this case, increase the column width. Set the width to optimal” by simply double-clicking the right divider in the column header." -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
