Retaining formatting when using the text function

[dotsofcolor]

I am trying to concatenate some text. I want to join A2 then D14, then B2, then E14 then C2. Think I have that in the right order. Anyway, I want to include in the sentence the text but also retain the percentage and number formats of D14 and E14.

I got this far and got stuck, how do I continue the formula? Or is there another method to try?

="For the years of 2005-2010 overall a "&TEXT(E14,"0.00%")

I included a sample and it should read like.

For the years of 1995-2010 overall a 5.27% reduction was achieved for a total of $47,731.15 for the project

[Ron Coderre]

Try this regular formula:

Please Login or Register  to view this content.

Note: I copied the number format by selecting cell D14, Format.Cells...Category: Custom....copy the Type: entry.
The Type format is: _($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)

I had to replace the "-" with \- so it could be included in the TEXT function.

Does that help?

[dilipandey]

Hi dotsofcolor,

Incorporate the following changes in your existing formula and it will work well

Please Login or Register  to view this content.

Regards,
DILIPandey

<click on below 'star' if this helps>