Hi

Change your cell to General and re-type your formula. Also make sure that
Tools/Options/View does not have 'Formulas' checked.

Andy.

"Bonnie" wrote in message
...
Hi everyone! Using E02 on XP. Having fits over this, can't figure out
what
is happening. Have a spreadsheet and want all of the records in Column AG
to
'read' the contract number contained in cell G1. First record is in row
4,
so in AG4 I typed =G1. Worked fine. Did a Fill;Down, realized I wanted
=G1
in each cell so I tried to key that into AG5 and all I get is the formula
(=G1) rather than the contract number. I've had that same problem with
other
formulas. My column is set to text, and I've tried changing the cell
formats
but to no avail.

It has GOT to be something stupidly simple that I'm missing. Need to get
this project done but sometimes formulas work and sometimes the formula is
just text in my cell.

Can anyone help me on this? Thanks in advance for any advice.
--
Bonnie