Mid Function Problem
This driving me crazy. I use functions all the time, but can not get this to
work.
I am trying to use the Mid function to grab the middle of a cell. Ex:
C3 = 100.44444.444444.444
I am using Mid(C3,5,5) to get the 5 digits after the first period. Anyway,
this works for the first cell, when I write the function in. But when I copy
and past the function down the worksheet, it returns the value of the first
formula I typed in, even the the function is referencing different cells down
the spreadsheet. When I push F2 on any of the wrong value-cells, and then
return, the function returns the right string.
Has anyone encountered this problem?
Thanks in advance.
DEI
|