Percentage referring another cell

[sock]

Hi

i am having Cell A1 25.8% I have to prepare a comment in Cell B2 like " Today sale is increased by 25.8%. if am referring cell A1 it is updating like Today sale is increased by 0.2554684515321124566.

i am having huge line items.


any help here.

Jack

 

[Coyotex3]

Maybe doing it like this.

=CONCAT("Today Sale is increased by ",TEXT(A1,"0.0%"))

 

[sock]

This works Thanks.....

 

[Joe4]

sock,
When marking a post as the solution, please mark the original post containing the solution, not your own post acknowledging that some other post is the solution.
I have gone ahead and updated this for you.