Question ID: 1114 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 right of the number and without decimal places. If the cell range contains any negative values, they should be displayed in red color, without the negative sign.

 

 

Other versions
Microsoft Excel 2003Microsoft Excel 2007Microsoft Excel 2013Microsoft Excel 2016Microsoft Excel 365Google Sheets

 

 

 


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 right of the number and without decimal places. If the cell range contains any negative values, they should be displayed in red color, without the negative sign.