View Single Post
  #2   Report Post  
Old June 28th 05, 05:00 AM
Anne Troy
Posts: n/a

Doesn't sound strange to me at all, Jeff...that is, if you have Calculation
set to manual.
~Anne Troy

"Jeff Brown" wrote in message
When I create a formula in a cell, then use the fill handle to copy the
formula down a column, the formula uses the data from the original cells
referenced instead of the cells in the rows down from the original cell.

the weird thing is, when I click on one of the filled cells, the formula
shows up correctly. Example, in Cell I2 I created CONCATENATE G2,H2 and
pulled down to fill down to row 52. Row 52 shows CONCATENATE G52,H52, but
the data is from cells G2 and H2. Strange.