J
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
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