MID function results

[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

 

[Sam Wilson]

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

Sam

 

[Glenn]

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

Change cell format to "General". Then hit F2 and Enter.

 

[Mike H]

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

 

[Mattlynn via OfficeKB.com]

=MID(A1,6,4) - i get the answer 5678
Does your formula in the spreadsheet have anything else contaoied within it.

You may also want to check manual and automatic calculation settings

Thanks