getting value from a cell into another cell behind a text string

G

Guest

Hi,

I'd like to know how to get a value from a cell into another behind a text
string by using a formula. For example,
A B
1 20 Result (20)

Thanks,
Xianbo
 
G

Guest

Use formatting

Pull-down Format > Cells... > Number > Custom and the the field enter:

"Result ("General")"

The advantage of using formatting is that the cell can still be used for
calculations
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top