I have an excel spreadsheet which pulls data from .csv files that are run from my company's database every 30 minutes. Some number data is formated to show a "+" sign in front of the positive numbers by using a custom number format [+0;-0;0].

I use the following string to combine the numbers with text:

=IF(E5="","","TECH - AHT "&FIXED(E5,0)&" sec.  //  Vol "&FIXED(G5,2)&"% to Forecast  //  "&FIXED(I5,0)&" Net Staff")
Both E5 and I5 have this custom formatting mentioned in the previous paragraph, but it is not translating to the cell where the above code resides. Can anyone help me?