excel course tate modern - Negative figures

Hi Muhammed, Just to put my twopence worth in, to do this you could also create a Formatting operation which will recognise that the value is negative and would format it in the style that you choose. Try following these steps; In your chosen worksheet select the area that you wish this Custom Formatting to appear, if it is the entire Worksheet, use the select all command (CTRL+A), go to the Menu option Format, Cells and in the Number tab, choose the Custom option; in the "Type" text box enter the following: #,##0.00;[Red](#,##0.00) this assumes that you will be entering decimal places, if this is not the case leave the .00 off, but you do need the hash signs (#) and the 0 (zero) before the decimal point, note it will assume you want to put the comma separation in your thousands, if not leave it out. I hope that helps regards Pete.