Concatenate Function ... Help .... Please!!

[tstruntz]

I am using the Concatenate function to string togehter text and formatted numbers (number, 2 decimal places and ( ) used for negative numbers). The whole string is a profit/loss discussion and analysis. The numbers I have referenced lose their formatting in the text string (concatenate function). Is there a way to keep the number format, or assign one while using the Concatenate function??

 

[tstruntz]

Dreamboat,

I will try your suggestion. I agree that it is easier to read and it may have more functionality.

Thank you for the tip!

 

[paelinck]

OK, so this is what the formula should look like:

=CONCATENATE("Any Company, USA Operations reported a combinded net ",H26, " of ", TEXT(G26,"""USD"" ###.###.##0.00;(""USD"" ###.###.##0.00)")," compared to a budgeted net ",I26," of ",TEXT(F26,"""USD"" ###.###,##0.00;(""USD"" ###.###,##0.00)")," for the month of ",B15)

Note the double-double quotes around USD. In general, if double quotes occur in the original format, you should double them in the formula.

I hope I didn't make any mistakes copying the formula from my Excel sheet: I'm working with a Dutch version with commas as decimal separators and semicolons as argument separators. So perhaps you'll have to make some minor ajustments.

Have a good day!
Marc



[/quote]