View Single Post
  #3   Report Post  
CLR
 
Posts: n/a
Default Formula writing problem

$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.