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

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+unsubscribe@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