formatting a sentence with functions
 

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

formatting a sentence with functions
 

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
---------------
Jacob Skaria


"Josh Craig" wrote:

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

formatting a sentence with functions
 

Works perfectly. Thanks for the quick reply Jacob!

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Josh Craig" wrote:

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