Hi,

First the obvious, you put this in the cell without any quotes
=MID(A1,6,4)

If that doesn't work hold down the CTRL key and tap `
The ' sign is generally to the left of the 1 key

or

Tools|Options - View tab and un-check 'Formulas'

Mike

"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