Numeric function and inserted text in same cell (2000)

Topic

New Reply

To anyone,
I would like to be able to insert both (1) a numeric function (i. e., A1+A2) in another cell (say, B1), and also (2) text that would follow the result of the numeric operation, but would be contained in the same cell.
Any clues?
Thanks,
Jeff

Reply | Quote

Replies

=A1+A2 & ” And The Text that follows A1+A2″

Reply | Quote

You could use

     =(A1 + A2 ) & "Text",

where Text is the text you want included.

However the formula result will bw text, and not numeric. If it is only for display purposes, and you require that cell value be a number, you can use the following custom number format :

    #,##0 "Text"

again where Text is the text value you want to display.

Andrew C

Reply | Quote

As usual, I am having a problem. I attach a file where I want the numeric result to include a $ and 4 decimal places. I can’t seem to find the custom format that does the trick!
Thanks,
Jeff

Reply | Quote

Just add the $ sign and number of Decimals you need

“$”#,##0.0000 “Text”

HTH

Peter

Reply | Quote

Thanks, Peter. See my most recent post above.

Reply | Quote

Just figured it out; Thanks. The trouble is when you insert the semi-colons (say for negative values), Excel seems to ingnore your directions!
Jeff

Reply | Quote

Attached is your w/b.

I applied the custom format

_(“$”* #,##0.0000_) ” per Pound”;_(“$”* (#,##0.0000) ” per Pound”,

though I am not sure it makes sense for negative values.

Andrew C

Reply | Quote