Retain cell format in text reference

[travellerva]

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 I get is "Color = 45019"

How can I get "Color = 4/3/23"?

Thanks

 

[shaowu459]

工作簿1
	A	B	C
1	2024-4-3		Color = 3/4/24
2
3
4
Sheet1

Cell Formulas
Range	Formula
C1	C1	="Color = "&TEXT(A1,"d/m/yy")

 

[travellerva]

Perfect!! Thank you so much. I should have thought of that

 

[shaowu459]

Perfect!! Thank you so much. I should have thought of that

you are welcome,have a nice day

 

[Olympas]

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.

 

[shaowu459]

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.

工作簿1
	A	B	C
1	15%	Increase by 15.00%
2		Increase by 15%
3
4
Sheet1

Cell Formulas
Range	Formula
B1	B1	="Increase by "&TEXT(A1,"0.00%")
B2	B2	="Increase by "&TEXT(A1,"0%")

 

[Olympas]

Thank you very much.