[libreoffice-users] Question about Calc and user-defined number formats

2014-02-16 Thread Tom Williams
So, I installed LibreOffice 4.2.0 on a Windows 7 system today and was showing the system owner how to use it. I created a new spreadsheet and added two columns and four rows, the last row being a total row that would show the sum of the previous rows. The first row I added was column headings.

Re: [libreoffice-users] Question about Calc and user-defined number formats

2014-02-16 Thread Brian Barker
At 11:27 16/02/2014 -0800, Tom Williams wrote: I selected cells B2..B5 and used the Format/Cells function to change the format to a currency format. I chose the -$1,234.00 in red format. The numbers in column B were changed accordingly. Then, my friend wanted only the first cell with a

Re: [libreoffice-users] Question about Calc and user-defined number formats

2014-02-16 Thread Tom Williams
On 02/16/2014 02:36 PM, Brian Barker wrote: At 11:27 16/02/2014 -0800, Tom Williams wrote: I selected cells B2..B5 and used the Format/Cells function to change the format to a currency format. I chose the -$1,234.00 in red format. The numbers in column B were changed accordingly. Then, my