I am looking for the operator that works like the dollar sign inLotus 123 in
front of cell value so that the value doesn't change when the formula is
copied.

Bob, =$A$1, to lock both column and row

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Bob" <Bob @discussions.microsoft.com wrote in message
...
I am looking for the operator that works like the dollar sign inLotus 123
in
front of cell value so that the value doesn't change when the formula is
copied.

$A$1 is an absolute reference to cell A1..........it will not change when
used in a formula and copied around.

Vaya con Dios,
Chuck, CABGx3


"Bob" <Bob @discussions.microsoft.com wrote in message
...
I am looking for the operator that works like the dollar sign inLotus 123
in
front of cell value so that the value doesn't change when the formula is
copied.