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