Dear Jonathan, Thank you very much for your kind and prompt reply.
Simply following your advice and selecting all, then default format allowed me to use the decimal point and add the columns. Your help is most appreciated, as it never occurred to me that it could be something so mundane as the formatting. (I thought I could use a larger bolder font to save eye strain - my bad.) Sincerely, Martin On Thu, 19 Jan 2006 14:56:42 +1100, Jonathon Coombes wrote: > On Wed, 2006-01-18 at 22:48 -0500, my wrote: >> Dear Friends, >> >> I have a slight emergency, as I am due in court friday, and the issue is >> as follows; >> >> in calc, oo version 2.0.0-1 if I enter a number with a decimal point to >> add up dollars and cents, the cell reads '###". > > This usually just means that the cell is not wide enough to > display the value inside. Try making the column a bit wider > and see if this fixes the problem. > >> If I use a dollar sign in front, the number appears, but the sum function >> does not work. > > Sounds like it is defaulting to text format then. > >> I I use a comma instead of the decimal point, the number appears, but >> again I cannot add the columns up. > > Ditto here for text. > >> What is wrong? > > Try and select the area you are having trouble with and then do a > Format -> Default Format or something similar. Then do a Format -> > Cells (or Column if appropriate) and define the format you require > (presumably currency of some form). Then try your numbers again > without the dollar sign. > > Regards > Jonathon --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
