Need result not formula in cells

[Bonnie]

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" <bonnielynnw@discussions.microsoft.com> wrote in message
news:169F6E0A-9DCC-4CE2-8E97-CF3C243AF8D1@microsoft.com...
> 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

[NancyJeanne]

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

[mr_ben]

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

[Bonnie]

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
>
>