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