On Fri, Jan 22, 2010 at 10:54 AM, James <[email protected]> wrote: > Can someone please try to duplicate this? > The problem occurs in both my Linux and Windows versions. > If you see the problem, maybe you can explain why it is doing it. > > sample file: > lockie.ca/test/receipt_list.ods.zip > > steps to reproduce: > 1. select cell C11 > 2. type =sum( > 3. select B3 to B9 with the mouse > 4. Press return > 5. Aug 17, 1916 is displayed but $6,074.52 was expected > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
I get $6,074.52. Maybe you need to double check the numbers format of that cell in your environment. If I change the numbers format of that cell to Date, I get something like Aug 17, 1916. -- WANG, Xiaoyun Shanghai, China --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
