formatting a sentence with functions

[Josh Craig]

Hi all,
I have this formula in a cell:

="market share is 100% until 2005 then reduces by "&(1-'Takeup'!L104)&" each
year."

The value in 'Takeup'!L104 is in percentage format but when I put it in the
above sentence it becomes a number format.

In other words, L104 contains: 15% but the above function gives me:
0.149654384.

Is there anyway to get it to actually display as a percentage in the result
of the above function?

Thanks for your help.

Josh

 

[Jacob Skaria]

Try the below which uses TEXT()

="market share is 100% until 2005 then reduces by " & TEXT(L104,"#%") &" each
year."

If this post helps click Yes

 

[Josh Craig]

Works perfectly. Thanks for the quick reply Jacob!