A cell can display at least 1024 characters and more if you hard code
returns in the string. So a cell should be able to handle 428 characters.
This includes xl97. In xl97, the limitation on a cell was increased to 32K
characters - although only 1024 will display or print (unless you embed hard
returns)

--
Regards,
Tom Ogilvy

"DRK" wrote in message
...
The legal types are making me put in footnotes into my spreadsheets which
exceed 255 characters. First one they sent down had 428 characters in it.
So
I can't put it in a cell or in a custom footer.

Please note: I'm running the official version approved by the company -
Excel 97.

I was thinking I could somehow plant a text box to hold the text. The text
will have variables in it. So I was going to use VBA to fill the box with
the
calculated text. But I'm having some diffculty with it as it is not on a
form.

Do I have any other options? Would a more recent or current version of
Excel
provide any solution?
--
DRK