Hello,

When ever we enter a negative $ amount, excel will automatically convert
that currency by enclosing bracket and in red.

I have an excel sheet, which contains currency as follows

$1234.00CR
$12.45CR
$12345677.00
etc.

Now it is displaying amount containing CR as is.

Is it possible to convert the above mentioned currency value which contains
CR as enclosed with brackets and in red.....

Please help me to solve this problem.

Thanks in advance,
Soundar.