View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lindsey-Star Lindsey-Star is offline
external usenet poster
 
Posts: 1
Default Why does it display #### in my cell?

In cell I25 I have the following formula: =SUM(I11:I14)
All it displays is #####, but when I hover over it, it gives me the correct
answer on a popup tip-like window which is $3,400. So, if it knows the
answer, why is it displaying with the pound signs instead? I think I've
tried everything.