how do I get whatever number is in a certain cell to another

[CAPT.PT]

I want to put whatever number that is in say cell Q6 in another cell along with a writin statement. For instance, in cell T6 I want writin: 11.2 * 27.50 * (whatever the number is in cell Q6)
I do not want this "formula" to work, I just want it to show up in cell T6.

So it might look like this, if cell Q6 had the number 4 in it:
11.2 * 27.50 * 4 =
Thank You,

 

[Andy Gee]

Use concatenate:

=CONCATENATE("11.2 * 27.50 * 4 = ",Q6)

 

[Aladin Akyurek]

On 2002-03-06 02:53, CAPT.PT wrote:
I want to put whatever number that is in say cell Q6 in another cell along with a writin statement. For instance, in cell T6 I want writin: 11.2 * 27.50 * (whatever the number is in cell Q6)
I do not want this "formula" to work, I just want it to show up in cell T6.

So it might look like this, if cell Q6 had the number 4 in it:
11.2 * 27.50 * 4 =
Thank You,

=11.2&" * "&27.50&" * "&Q6&" ="
This message was edited by Aladin Akyurek on 2002-03-06 03:03

 

[CAPT.PT]

Thank you Aladin, your suggestion worked out perfect......God Bless! Stay Safe & have a great day!