I have a formula that takes 20 characters from the Left of one cell to put them in the one next to it.
the formula works fine if i enter it use A1 notation and when i fill down the formula changes cell references relatively, but the value delivered is that of the copied cell and not of the changed reference.
so i tried simplifying it and just changed the one cell to a formula equal to the other cell, same problem. if i directly enter works fine but when i fill down it keeps giving the value of the original cell rather than the relative cell reference actually contained in the cell when i look at the underlying formula.
i though maybe its a calculation thing, but i tried changing formats (which i thought were general already). i haven't set any value only key i'm aware of relative to fill down and it actually is filling with a correctly rleative referenced formula.
to say it is driving me crazy wouldn't do it justice. i've never seen anything like it.
Bookmarks