Delete B1, format it as general and then re-type =MID(A1,6,4) in it.

Sam


"Maria" wrote:

The results of a MID function is the formula, not the requested text.
For example
Col A1 = 1234.5678
Col B1 displays "=MID(A1,6,4)", not "5678"
I have tried several cell formats but cannot get it to display properly.
Thanks