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
|