add notes

[reza]

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

 

[Kassie]

=A1&"pieces"

--
HTH

Kassie

Replace xxx with hotmail

 

[Billy Liddel]

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