# Thread: Number & Text (2003)

1. ## Number & Text (2003)

Loungers, further to an earlier post regarding this. I have developed a formula ="This represents a "&TEXT(L22,"#0%")&" from "&TEXT(J22,"#")&" in"&TEXT(\$J\$6," mmmm")'. This returns a value of , "This represents a -1.33333333333333% increase from 75 in May".

How can if change the formula to return "This represents a -1.3% increase from 75 in May"

2. ## Re: Number & Text (2003)

I guess:

="This represents a "&TEXT(L22,"#0.0%")& IF(L22>0,"in","de") & "crease from "&TEXT(J22,"#")&" in"&TEXT(\$J\$6," mmmm")'

3. ## Re: Number & Text (2003)

The formula as posted would result in "This represents a -1% from 75 in May". To display the percentage with one decimal place, use <code>TEXT(L22, "#.0%")</code>, and you need to add the word increase.

<code>="This represents a "&TEXT(L22,"#.0%")&" increase from "&TEXT(J22,"#")&" in"&TEXT(\$J\$6," mmmm")</code>

4. ## Re: Number & Text (2003)

Thanks Jan & Hans for the suggestions.

I thought it better that I attached a cutdown version of the spreadsheet so you can see what I need to do

5. ## Re: Number & Text (2003)

Cells L13, L16, L19 and L22 contain a concatenation, therefore text. Applying the TEXT function to them has no effect. You must use the TEXT function in the formulas for L13 etc. Moreover, you should put the % sign in the TEXT function, not in the formula that determines increase/decrease.

6. ## Re: Number & Text (2003)

Hans, you've do it again!!

Thanks very much

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•