Hi,

In Excel 2007 I am trying to develop a macro which combines different workbooks spreadsheet into single workbook. In which some of the sheet has custom cell format of showing negative figures in round brackets ( ).

But when sheets are combined into 1 workbook it doesn't pulls the above custom format of the cell rather it shows figures with negative sign i.e negative sign which i want to avoid.

Even I tried recording macro which pulls different sheets into single workbook and to change the custom format of the cell which shows negative figures. It worked while recording but after executing the macro it doesn't change the format of cell it shows the figures with minus sign.

Could you please provide me a solution for the above.

Kind Regards,
Subramanian