How to add parentheses...

Hi,

I work in school and and I have to enter test marks of students in excel 2003.
Here is my question:
If student's mark is below 40(e.g. 32), I want to indicate it by (32).
How can I do it? It seems that condition formatting can't help...

Thanks!

You could enter the raw mark in one column, and have the 'adjusted' text show in a column next to it.

The formula would be IF(a1<40, "(" & A1 & ")", A1) - assuming that the raw mark is in A1.

Conditional formatting will allow you to chnge the fond, text colour or background shading dependent on the cell value. It cannot however change the text/number by adding characters itself. The best option is to mark the offending results as a different foreground/background colour.

Number formatting can optionally change the apperance of a number, however it has hard coded boundaries of less-than-zero; zero; greater than zero. As you problem does not relate to a value <0 or >0, the solution is not applicable.

So, in short, it is not possible to do without programming.