View Single Post
  #2   Report Post  
Gary''s Student
 
Posts: n/a
Default getting value from a cell into another cell behind a text string

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
--
Gary''s Student


"Xianbo" wrote:

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