Thanks:  0
Likes:  0

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

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

2. Use concatenate:

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

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

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

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•