Reference a cell in a sentence that contains a percentage - cannot reproduce format.

[Olympas]

Retain cell format in text reference

I am trying to generate content in a cell that comprises a text component followed by the contents of a variable cell. I need to retain the format of the content in the referred cell. Thus, my formula is: ="Color = "&A258 where A258 will contain a date in short date format (e.g. 4/3/23). What...

www.mrexcel.com

Hi, this almost did it for me after i searched for "cell reference and format". I am referencing a cell in a sentence using "&A1&" where A1 contains a percentage, 15%. However, the formula returns (understandably) "0.15". How can i format this so it shows "15%"? Thank you.

 

[Alex Blakenburg]

Try

="xxx "&TEXT(A1,"0%")&" yyy"

 

[Olympas]

perfect, thank you.

 

[Alex Blakenburg]

You're welcome. Glad I could help.