On Friday 11 November 2005 07:24, Paul wrote: > This happens because there is a number in the cell when formatted as > text. When you change the format to be a number, calc assumes you want > the 'text' that was in the cell to remain as is. In order to do that, > it inserts a ' in the cell. > > Since cells are, by default, formatted as numbers > general, it may > pay to format the cells as you want them prior to inserting anything.
To add a little, To get them back to number, we must delete the ' sign. -- Fajar Priyanto | Reg'd Linux User #327841 | Linux tutorial http://linux2.arinet.org 08:07:24 up 46 min, 2.6.11-1.1369_FC4 GNU/Linux Let's use OpenOffice. http://www.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
