add notes

  • Thread starter Thread starter reza
  • Start date Start date
R

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
 
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
 
Back
Top