text field limit

[tkaplan]

I have a form where i have cells B9:I21 merged together. the alignment is to wrap text and the format is a text field. all's fine until i reach the third line of text. it is all displayed as #######. is there a limit of text allowed in a text box???? how can i go around this?

i put in the following text but as soon as i put another space it swiches to #'s.:

Q1: DEP RPTS WERE NOT ON FILE AND HAD TO BE PRINTED. ONCE PRINTED TWO OUT OF 3 DID NOT AGREE B/C DIR TRANSPOSED AMT ON ONE AND DEP A PMT ALMOST A MTH AFTER POSTED.
Q3B: INCORRECT AMTS POSTED TO FAMILIES PER CHK DETAIL AND APPLIED TO INCORRECT DATES.
Q6:

i know that there is a display limit of 1024, but the length of the above text is 254 so i cant figure out what's goign on.

Thanks in advance

[Dave Peterson]

Try formatting the cell as General.

When you use a number format of Text, excel will have trouble with strings
between 255 and 1024 characters.

tkaplan wrote:
>
> I have a form where i have cells B9:I21 merged together. the alignment
> is to wrap text and the format is a text field. all's fine until i
> reach the third line of text. it is all displayed as #######. is there
> a limit of text allowed in a text box???? how can i go around this?
>
> i put in the following text but as soon as i put another space it
> swiches to #'s.:
>
> Q1: DEP RPTS WERE NOT ON FILE AND HAD TO BE PRINTED. ONCE PRINTED TWO
> OUT OF 3 DID NOT AGREE B/C DIR TRANSPOSED AMT ON ONE AND DEP A PMT
> ALMOST A MTH AFTER POSTED.
> Q3B: INCORRECT AMTS POSTED TO FAMILIES PER CHK DETAIL AND APPLIED TO
> INCORRECT DATES.
> Q6:
>
> Thanks in advance
>
> --
> tkaplan
> ------------------------------------------------------------------------
> tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
> View this thread: http://www.excelforum.com/showthread...hreadid=483472

--

Dave Peterson

[tkaplan]

thank you for your response Dave.

Do you know why it is that it has trouble after the 254?

[Dave Peterson]

A long time ago, the most you could put into a cell was 255 characters. Maybe
it was some kind of holdover from that. (I have no idea, really.)

tkaplan wrote:
>
> thank you for your response Dave.
>
> Do you know why it is that it has trouble after the 254?
>
> --
> tkaplan
> ------------------------------------------------------------------------
> tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
> View this thread: http://www.excelforum.com/showthread...hreadid=483472

--

Dave Peterson

[RagDyeR]

Wouldn't that simply be another generic insect name ,,, a bug!<g>
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:43721CF2.76B10A4B@verizonXSPAM.net...
A long time ago, the most you could put into a cell was 255 characters.
Maybe
it was some kind of holdover from that. (I have no idea, really.)

tkaplan wrote:
>
> thank you for your response Dave.
>
> Do you know why it is that it has trouble after the 254?
>
> --
> tkaplan
> ------------------------------------------------------------------------
> tkaplan's Profile:
http://www.excelforum.com/member.php...o&userid=22987
> View this thread: http://www.excelforum.com/showthread...hreadid=483472

--

Dave Peterson