Hi,

I have a list of letters and numbers in B2. I am putting in the formula
=b2 in the cell next to it and dragging the formula down. The formula
looks fine if I go into each cell and has copied correctly i.e =b3, =b4
e.t.c but all the cells show the info from b2?!?!?! if I click the = for
a non working cell and then ok it calculates it correctly but I have
thousands of them to do.

Please help!!!

Scott.


--
ScoTTyBEEE
------------------------------------------------------------------------
ScoTTyBEEE's Profile: http://www.excelforum.com/member.php...o&userid=28263
View this thread: http://www.excelforum.com/showthread...hreadid=478260