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 -- OOo Tips: http://mindmeld.cybersite.com.au/tips.rss OOo Knowledgebase: http://mindmeld.cybersite.com.au Training4Linux: http://www.training4linux.com Cybersite Consulting: http://www.cybersite.com.au --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
