Data formatting

Hi Terry

Thank you for your question

First select the cells to format and then click on format-cells and click on the number tab. Next select the custom option from the category list and type the following into the type text box on the right hand side of the dialog

#,##0;[Red](#,##0)

The element before the semi colon shows the format if the number is positive and after when it is negative. Note the word red in square brackets and the brackets around the number format showing that the negative number is red and in brackets

Regards

Stephen