If you're building the formula using the mouse and you're pointing at a
different workbook, you'll see those absolute reference $. That's the way excel
works.

But if you're typing the formula manually, I've never seen excel do this.

But you can cycle through the absolute references by selecting the formula in
the formulabar (or just a portion of the formula) and hitting F4.

$h$7
$h7
h$7
h7

(maybe not in that order, though.)

DCLBaker wrote:

Hi, Does anyone know who to resolve this problem? Every time I do a
formula it automatically adds a $ to the column and row reference so that
the formula looks like this: =sum$H$7. I am having to use the €œreplace€� to
remove the $. Somehow I turned on this method and I cant figure out how
to turn it off.

Anyone got a suggestion?

--

Dave Peterson