You cannot enter more than 1024 characters in a formula.

No way around it.

What kind of formula would have 3000 characters?

Describe what you hope to achieve, other than stuffing 3000 characters in a
formula that is.

There may other methods or formulas that would apply.


Gord Dibben MS Excel MVP


On Sun, 24 Sep 2006 17:34:01 -0700, Moh wrote:

how can i make a cell unlimited.
so that i can enter upto 3000 characters into it.
for e.g so i can put in a long formula)

thank you, i hope someone can reply fast.