Question ID: 5411 5/29
PREVIOUS QUESTION NEXT QUESTION

Format the cell range C20:J21 of the SALES worksheet so that the numbers are displayed with a thousand separator, the $ currency symbol is displayed on the left of the number, without decimal places and with one leading zero. If the cell range contains any negative values, they should display in red color, without a negative sign.

 

 

Other versions
OpenOffice.org Calc 3.3LibreOffice Calc 4.0

 

 

 


Format the cell range C20:J21 of the SALES worksheet so that the numbers are displayed with a thousand separator, the $ currency symbol is displayed on the left of the number, without decimal places and with one leading zero. If the cell range contains any negative values, they should display in red color, without a negative sign.