concatenate a figure and a text keeping figure format in percentage

[waldymar]

Dear All,

I use a formula concatenating a figure and "*" (asterix). I wish the figure format to be expressed in percentage. How can I make it?

Thanks in advance.

 

[VoG]

Try like this

=TEXT(A1,"0.00%")&"*"

 

[waldymar]

Try like this

=TEXT(A1,"0.00%")&"*"

Perfect! Appreciate so much!

 

[waldymar]

Try like this

=TEXT(A1,"0.00%")&"*"

Another problem appeared. If I have a negative figure then together with asterix it makes it a positive one. But I apply a conditional formatting and say that if figure is negative then cell to be red. However, now negative numbers with asterix are shown as positive. Any solutions?

 

[VoG]

It doesn't do that here but remember that the concatenated value is text, not a number

Excel Workbook
	A	B
1	-1	-100.00%*
Sheet1

 

[waldymar]

It doesn't do that here but remember that the concatenated value is text, not a number

Excel Workbook
	A	B
1	-1	-100.00%*
Sheet1

how can I still apply conditional formatting in case of asterix?

 

[VoG]

Try like this

Excel Workbook
	A	B
1	-1	-100.00%*
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1	1. / Formula is =A1<0	Abc

 

[waldymar]

The thing is that I'm not using any supplementary cell but directly the same cell like

=TEXT(VLOOKUP($E18,BondData!$B$4:$DJ$100,MATCH("YTD Performance",BondData!$B$2:$BP$2,0),0),"0.00%")&" *"

In this case how can I apply the conditional formatting?

 

[VoG]

Try this CF formula

=LEFT(B1,1)="-"

Change B1 to your concatenated cell.