Hi,

It is strange problem with me. When I type "(1)" in particular cell it changes to "-1" when I click that cell. When I delete "-" , it becomes "1". When I try to add "()" again around "1". It becomes "-1".

please help.

regards

Parentheses ( ) around a number is one of the ways to specify a negative number; it is sometimes used in bookkeeping.

If you don't need to perform calculations with the values, you can set the number format of the cells to Text, or prefix the value with an apostrophe: if you enter '(1), Excel will display (1) and treat the value as text.

Thanks Hans Vogelaar,

regards