The most likely culprit is that you have formatted that cell as Text.
Go to the Format menu, choose Cells, and there the Number tab. In the
list, choose General (or some other format) and click OK.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Sat, 20 Dec 2008 14:28:08 -0800, krum35
wrote:

I have made a cell with the following formula

=C2

However, instead of placing the value in C2, it is reading "=C2"