You do not have to capitalize the entries. If Excel believes
what it sees is a formula it capitalizes the cell references by itself.
Since it didn't, that means there is something wrong with the entry.

One more thing you can do is verify that the cells, to which you are
transferring the formulas are formatted, as General not Text.

Jim Cone


"Lisa H via OfficeKB.com" wrote in message ...
Okay I went through and capitalized them all and checked the values they
are using and it's coming up correct is there something I am missing?
Unfortunatley I am a self taught Excel user and I just can't figure out
what I am doing wrong.

--
Message posted via http://www.officekb.com