Thanks for the recognition. I'm just happy to help! :)
Elkar

"David Gerstman" wrote:

Elkar,

That did it! Thanks so much.
It was for a superior at work so I really appreciate it.
(Yes, I credited you. He knows I got help. He has a print out of the correct
answer.)
David

"Elkar" wrote:

Ok, now I think I see whats going on. When you use the mouse to click on the
cell to create the reference, it carries over the TEXT format as well. The
formula gets created properly as a formula, but contains an incorrect cell
referrence. Then, any subsequent changes to the formula use the TEXT
formatting that was carried over.

Now, once you've remove the :I7 portion, change the format back to
"General". But, this time, instead of re-entering the formula, just hit F2
to edit the formula, then Enter. This should reapply the formula using the
"General" format.

For future references to merged cells, it may be better to just type in the
formula rather than using the mouse to select the cell.

HTH,
Elkar