On 01/21/10 22:24, Brian Barker wrote:
At 21:54 21/01/2010 -0500, James Lockie 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
This is no problem: the spreadsheet is behaving as it is intended to.
The values in your column B are not currency amounts but numbers; they
display as currency amounts only because the column is formatted that
way. Likewise, the values in column C are also numbers, but this time
display as dates because the column has been formatted as date. When
you sum the numbers in column B you get a number for the sum. Placed
in column B, this displays as a currency amount, as you expect; in
column C, the same value displays as a date, since C11 (along with the
rest of column C) has been formatted as date.
If you format C11 as currency, either before or after you insert the
formula, you will see the result you desire.
I trust this helps.
Brian Barker
Thanks for the explanation, it should have been obvious to me. :-)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
