Please see attached for example. In column D of attached I have a formula as follows:What I would like to do is to line up the left brackets with one another. I modified the code per below, which lines up the brackets but that puts in a leading zero, which I do not want to see.![]()
=IF(C8=0,"","{ "&TEXT(C8/$C$4,"##.0%")&" }")
. Any suggestions appreciated. Thanks in advance![]()
=IF(C8=0,"","{ "&TEXT(C8/$C$4,"0#.0%")&" }")
Bookmarks