| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
display value as % in concantenated cell
Hi,
I'm using the REPT function to create in cell graphing which I found @ http://blogs.ittoolbox.com/bi/juicea...graphing-11035 My problem is that when I try to add a data label by concatenating the cell value I don't get the percentage. Is there a way of specifying that you want the percentage format dispayed as a label in the graphing cell? or would it be best to calculate % in number formatted cell? This is the formula I'm using =IF($N14<0,N14&" "&REPT("|",-$N14*100),"") Many thanks -- Smudge |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display value as % in concantenated cell
Here is a general method; if A1 contains:
the percentage is and B1 contains 5% then =A1 & B1 displays the percentage is 0.05 but =A1 & TEXT(B1,"0%") displays the percentage is 5% Using the TEXT() function allows you to capture the proper formats -- Gary''s Student - gsnu200744 "Smudge" wrote: Hi, I'm using the REPT function to create in cell graphing which I found @ http://blogs.ittoolbox.com/bi/juicea...graphing-11035 My problem is that when I try to add a data label by concatenating the cell value I don't get the percentage. Is there a way of specifying that you want the percentage format dispayed as a label in the graphing cell? or would it be best to calculate % in number formatted cell? This is the formula I'm using =IF($N14<0,N14&" "&REPT("|",-$N14*100),"") Many thanks -- Smudge |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display value as % in concantenated cell
Hi
Try =IF($N14<0,TEXT(-N14/100,"0.0%")&" "&REPT("|",-$N14*100),"") -- Regards Roger Govier "Smudge" wrote in message ... Hi, I'm using the REPT function to create in cell graphing which I found @ http://blogs.ittoolbox.com/bi/juicea...graphing-11035 My problem is that when I try to add a data label by concatenating the cell value I don't get the percentage. Is there a way of specifying that you want the percentage format dispayed as a label in the graphing cell? or would it be best to calculate % in number formatted cell? This is the formula I'm using =IF($N14<0,N14&" "&REPT("|",-$N14*100),"") Many thanks -- Smudge |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display value as % in concantenated cell
Thank you Gary :-)
-- Smudge "Gary''s Student" wrote: Here is a general method; if A1 contains: the percentage is and B1 contains 5% then =A1 & B1 displays the percentage is 0.05 but =A1 & TEXT(B1,"0%") displays the percentage is 5% Using the TEXT() function allows you to capture the proper formats -- Gary''s Student - gsnu200744 "Smudge" wrote: Hi, I'm using the REPT function to create in cell graphing which I found @ http://blogs.ittoolbox.com/bi/juicea...graphing-11035 My problem is that when I try to add a data label by concatenating the cell value I don't get the percentage. Is there a way of specifying that you want the percentage format dispayed as a label in the graphing cell? or would it be best to calculate % in number formatted cell? This is the formula I'm using =IF($N14<0,N14&" "&REPT("|",-$N14*100),"") Many thanks -- Smudge |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display value as % in concantenated cell
Thank you Roger :-)
-- Smudge "Roger Govier" wrote: Hi Try =IF($N14<0,TEXT(-N14/100,"0.0%")&" "&REPT("|",-$N14*100),"") -- Regards Roger Govier "Smudge" wrote in message ... Hi, I'm using the REPT function to create in cell graphing which I found @ http://blogs.ittoolbox.com/bi/juicea...graphing-11035 My problem is that when I try to add a data label by concatenating the cell value I don't get the percentage. Is there a way of specifying that you want the percentage format dispayed as a label in the graphing cell? or would it be best to calculate % in number formatted cell? This is the formula I'm using =IF($N14<0,N14&" "&REPT("|",-$N14*100),"") Many thanks -- Smudge |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display text in one cell as a number in an adjacent cell in excel | New Users to Excel | |||
| a cell to display number of days in a month given in another cell | Excel Worksheet Functions | |||
| Display contents of cell in another cell as part of text string? | New Users to Excel | |||
| How to click on a cell and have the content of the cell display in a different cell | Excel Worksheet Functions | |||
| Text concantenated with a link to another spreadsheet field | Excel Worksheet Functions | |||
Linear Mode
