Formating cells with certain formula

[tomvh444]

I have a column of cells in worksheet "B" that has this formula to fill those cells with data from another worksheet, "2010H&A":

=REPT(INDEX('2010 H&A'!$F$7:$F$643,MATCH($B9&":"&$C9&":"&$F9,'2010 H&A'!$P$7:$P$643,0)),1)

I am using the number format where a positive number is in black and a negative number is in red with (). Example 3.5 appears as 3.5 and -3.5 appears as (3.5) in red. With the above formula, when I enter -3.5 in the cell in worksheet "2010H&E" it presents correctly in that cell as (3.5) in red, but in the corresponding cell in worksheet "B" it appears as -3.5 in black. I have of course tried several times to format the column of cells in worksheet "B" the same as the number format in worksheet "2010H&E", but it does not work. Can you help?

[TMS]

Might be helpful to post a sample workbook.

Regards

[tomvh444]

Not sure how I attach a workbook

[TMS]

click on Go Advanced.
click on thr paperclip icon.
click on browse.
navigate to your folder/file
select the file
click on upload
close the window
submit

Regards

[tomvh444]

Thanks for the instruction, I had not done an attachment on this forum before. Here it is. As you look at the workbook, you will see in worksheet "2010 H&A under column F the negative numbers are formatted to appear in red with the ( ). In worksheet "2010away T1" those numbers are presented in column G, but the negative numbers present as -3.5 etc. This is not a "must have", but I would prefer to have all my negative numbers appear in red and the positive numbers in black.

[DonkeyOte]

REPT is a TEXT based function so it returns strings rather than numbers and as such number formats are ignored.

For the sake of Column G modify the formula to:

Please Login or Register  to view this content.

at which point your existing number formats should take effect and Null strings will be returned as appropriate.

[tomvh444]

Sorry for the delay in my response. I had a sudden illness and am just now back up and running. I will make the change from TEXT and thank you so much.