| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formatting functions not working | Setting up and Configuration of Excel | |||
| Formatting text within functions | Excel Worksheet Functions | |||
| Functions and formatting | Excel Discussion (Misc queries) | |||
| formatting problem with functions | Excel Worksheet Functions | |||
| Formatting in IF Functions | Excel Worksheet Functions | |||
Linear Mode
