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

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

Besides changing format to general you need to insert $ ex: =G$1 will lock
the first row.

"Bonnie" wrote:

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

agreed it all to do with lock the cell by adding a '$'

for example...


$D$5 would lock the cell in a formula and no matter where you paste it
D5 would be linked.

D$5 would lock the row, so the column would alter in relation to it's
original position but not the row

$D5 would lock the column, so the row would alter in relation to it's
original position but not the column.



HTH


--
mr_ben
------------------------------------------------------------------------
mr_ben's Profile: http://www.excelforum.com/member.php...o&userid=37106
View this thread: http://www.excelforum.com/showthread...hreadid=567500

Hi Mr. Ben!

Thanks VERY much for the reply. I will print this one for my notes.

Exactly what I needed with a wonderful explanation that made perfect sense
and now I can still use the 'fill;down' feature to copy my formula!

Thank you for your time helping others.
--
Bonnie


"mr_ben" wrote:


agreed it all to do with lock the cell by adding a '$'

for example...


$D$5 would lock the cell in a formula and no matter where you paste it
D5 would be linked.

D$5 would lock the row, so the column would alter in relation to it's
original position but not the row

$D5 would lock the column, so the row would alter in relation to it's
original position but not the column.



HTH


--
mr_ben
------------------------------------------------------------------------
mr_ben's Profile: http://www.excelforum.com/member.php...o&userid=37106
View this thread: http://www.excelforum.com/showthread...hreadid=567500