View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default Function displays as text, doesn't return result or error

You might have calculation mode set to manual - go to Tools | Options |
Calculation (tab) and ensure that Automatic is checked.

Hope this helps.

Pete