THANK YOU SO MUCH! This was it. I don't understand why it switched to that
or what manual calculation is - but it was making me crazy. Much appreciated.

"Bob Umlas" wrote:

Office Button/Excel Options/Formulas, select Automatic calculation.


"A" wrote in message
...
I am having an issue that is driving me crazy. I have always had a trick
of
converting numbers in cells using the formula "*1". Example, if you have
a
zip code that leads with 0 and you need to get rid of the zero. If you
enter
=Zip Code *1, it would return a four digit zip code. This always worked
for
me in a number of ways. Now, I am having the weirdest thing happen. When
I
type in this formula, it works for the first cell but when I copy it down,
it
is only return the content of the first cell, even though the formula is
updating to reflect the correct cell.

Example if cell A1 = 05444 and in cell b1 I type =a1*1, b1 returns the
value
5444
When I copy down the formula, the formula reads correctly in b2, but still
returns the result 5444.

Anyone have any idea what I'm talking about?? *1 was always my trick and
now it's not working. I'm using Office/Excel 2007.

Thanks!