Conveying custom number format to new cell via formula

**delirium** · 04-02-2009, 06:32 PM

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:

Please Login or Register  to view this content.

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?

**Paul** · 04-02-2009, 10:03 PM

Hi Delirium,

Not sure if this is what you're after, but try:

=IF(E5="","","TECH - AHT "&TEXT(FIXED(E5,0),"+0;-0;0")&" sec. // Vol "&TEXT(FIXED(G5,2),"+0.00;-0.00;0.00")&"% to Forecast // "&TEXT(FIXED(I5,0),"+0;-0;0")&" Net Staff")