View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default Function wont work!?

This suggests the format of the cell/column is TEXT ... change to GENERAL.

"Jonas" wrote:

Hello,
I have a database in excel with 6 columns and about 4 000 rows. Whenever I
try to make a worksheetfunction in this database, and it only returns the
formula text (i.e. =SUM(B5:B10)). I this supposed to be like this (limitation
in ecxel or is it some kind of settings I have to change?

Cheers
Jonas