Thread: MID function results
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Maria[_4_] Maria[_4_] is offline
external usenet poster
  
Posts: 2
Default 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

Reply With QuoteReply With Quote