Spreadsheets

Dear Liz

Thank you for attending Excel Intermediate course!! I hope you enjoyed the course and benefited from it.

To achieve your results please follow these steps:

1. Select the cells that you wish to format

2. Choose Format > Cells from the Menu Bar

3. Choose Custom from the category section

4. Enter the following code #,##0;(#,##0);0

5. Press Ok button.


I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT