| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function wont work!?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup function wont work for copied data | Excel Worksheet Functions | |||
| IF sum is GreaterThan 0... why wont this work!? | Excel Worksheet Functions | |||
| Control + C wont work | Excel Discussion (Misc queries) | |||
| Anyone know why this wont work? | Excel Programming | |||
| Why Wont This Work? VBA Help Needed! | Excel Programming | |||
Linear Mode
