how to format -ve values

[Ratan Bhushan]

Hi team

Below is the screen shot of my sample data where I am getting negative values.

I have attached the file. here in -ve values, I want them to be appeared

comma separated format
red font color
starts with bracket rather than showing "-" sign but if we check in formula bar it shows "-".

How to get this format.

I don't want values to be converted in text.

Thanks
RatanB

 

[Hui]

Apply a Custom Number Format of #,###.00;[Red](#,###.00);

Select A1:A7
Ctrl+1
Number Tab, Custom
Enter #,###.00;[Red](#,###.00);
Apply

The Formula bar always shows the Number as a Number not as it is formatted

 

[Ratan Bhushan]

Apply a Custom Number Format of #,###.00;[Red](#,###.00);

Select A1:A7
Ctrl+1
Number Tab, Custom
Enter #,###.00;[Red](#,###.00);
Apply

The Formula bar always shows the Number as a Number not as it is formatted

Thank you sir

It worked...