MID function results

  • Thread starter Thread starter Maria
  • Start date Start date
M

Maria

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
 
Maria said:
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
Click to expand...

Change cell format to "General". Then hit F2 and Enter.
 
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
 
Back
Top