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. The second row I added had text in the first cell and the number "50" in the second cell. The third row I added had text in the first cell and the number "40" in the second cell. The fourth row was blank. The fifth row was the "total" row. Cool. So, 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 number to have a dollar sign and the numbers below it to NOT have a dollar sign. So, I selected cells "B3..B5" and used the "Format/Cells" function to change the format. When the "Format Cells" window appeared, the "Currency" number format was selected, as expected. I went to the "Format code" box and simply removed the "$$" references, leaving the rest of the format code intact. The Category immediately changed to "User Defined", which is fine. Here's the problem: after the category changes to "User Defined", the modified format code, which is still displayed, doesn't apply to the selected cells and I can't find any way to save the modified currency format as a user defined format I can reuse. I tried changing the comment of "User-defined" to something else, thinking that might be used as a category name or something. What am I doing wrong? Thanks in advance! Peace... Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted