
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...
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.