MID function results
 

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

MID function results
 

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

MID function results
 

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


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

MID function results
 

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

MID function results
 

=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



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

--
Matt Lynn

Message posted via http://www.officekb.com