minus problem in excel

Question

i have entered the number with minus sign before it (ex: -1500) in the cell. if i enter into the another cell it was appeared as **(1500)**i want the whole column like that ie., i will paste the info from another sheet to current sheet i want the copied data as shown in the Bold which i was unable to do it please help me with this issue.

Answer 1

• Select the entire column which you want to format.
• Press Ctrl+1 and Click then Number Tab.

• Set Decimal places: as "0" (Zero)
• Select (1234) and Click on Ok.

Best of luck.

Answer 2

You are wanting to change the display for negative numbers so as to put the brackets around the negative numbers. You can select the column or specific cells and follow below steps:

Right click the selected cells / column and chooseFormat Cells from the context menu;

In the Format Cells dialog box, under Number tab, click Number option, and then choose the decimal places as you need;

And then click (1234) in theNegative numbers list box;

Then click OK to close this dialog, and the selected negative numbers have been displayed around brackets.

You can display Bold in a similar manner - In the Format Cells dialog box, under Fonttab, click Font Styleoption, select Bold.

You may refer below link for further details and images:

https://www.extendoffice.com/documents/excel/1953-excel-display-negative-numbers-in-brackets.html

Regards,

Amit Tandon

www.globaliconnect.com