On Wednesday 11 January 2006 09:54 pm, Carl Karsten wrote: > >>Is there a way for a worksheet to display '0' (or any other > >> > >>> > character/word) when the cell is left empty? Thanks. > >> > >> So if it was a new sheet, you want all the cells to show 0's? > > yes!
I don't know how to make it automatic, but, you can type 0 at cell A1, copy it, and then click on the most upper left button on the sheet (the box located at the left of A column, and at the top of row 1) to select all cell in the sheet, and then paste (ctrl V). -- Fajar Priyanto | Reg'd Linux User #327841 | Linux tutorial http://linux2.arinet.org 13:02:44 up 3:16, 2.6.14-1.1653_FC4 GNU/Linux Let's use OpenOffice. http://www.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
