Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NOTES FOR A CELL | Excel Worksheet Functions | |||
DELIVERY NOTES | Excel Worksheet Functions | |||
Notes | Excel Discussion (Misc queries) | |||
Notes in Outlook | Excel Discussion (Misc queries) | |||
Cell Notes | Excel Discussion (Misc queries) |