| 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 |
| 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 | |||
Threaded Mode
