add notes
 

Hi guys....

can we add detail if we link cell...
example
Col A
1 100
2 8

now in another sheet i want to link col A1.
usually the simply way just =A1 .... then will show 100.
now i want to add words... i want become 100 pieces

thanks

reza

add notes
 

=A1&"pieces"

--
HTH

Kassie

Replace xxx with hotmail


"reza" wrote:

Hi guys....

can we add detail if we link cell...
example
Col A
1 100
2 8

now in another sheet i want to link col A1.
usually the simply way just =A1 .... then will show 100.
now i want to add words... i want become 100 pieces

thanks

reza

add notes
 

Or you can use a custom format.
Select the range to format
On the Number format tab choose Custom, Number, and in the Type box type 0
"Pieces"

It is easier to perform operations this way (addition, subtraction, ...)

HTH, Peter A

"reza" wrote:

Hi guys....

can we add detail if we link cell...
example
Col A
1 100
2 8

now in another sheet i want to link col A1.
usually the simply way just =A1 .... then will show 100.
now i want to add words... i want become 100 pieces

thanks

reza