Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to use spellnumber formula | Excel Worksheet Functions | |||
Currency to Text | Excel Worksheet Functions | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Median result used in formula gives incorrect result | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions |