Tim,
Yes, the first "paragraph" is greater than 255 characters (it's actually 323
characters long). So why does it display okay when the cell is formatted as
General, but not okay when formatted as Text? I would have thought that I
would get "#############" regardless of the format.
Bob

"tim m" wrote:

I get the same results as you when tested. After doing a quick web search, I
believe that perhaps you have exceeded a character limit per cell (255 I
think). Once i removed some characters from the longer paragraph it reverted
to showing the text rather than the #'s If you add a bunch of chracters to
your shorter paragraph it to will display #'s once it reaches a certain
length.

"Bob" wrote:

1) Copy the following paragraph to cells A1 and A2 (be sure to remove the
line breaks that this web site adds):

Placing this project in yellow as Company ABC has NOT provided as yet, the
T&C1 to the MOM. Both have been overdue since mid-June. Escalations within
Company ABC and from Company XYZ leadership has not changed the status.
Meanwhile, Company ABC PM is reporting that INSTAR test support is an issue.
Sahni has escalated numerous times on both issues.

2) Format A1 with the General format; format A2 with the Text format.
Notice that A1 looks normal, but A2 shows €œ###########################€�

3) Now copy the following paragraph to cells A3 and A4 (again be sure to
remove the line breaks that this web site adds):

10/31 [tm0622] - Request for swBRD to be baselined via e-mail, because it is
late. 10/23 - swBRD - not baselined, T&C (1) to be delivered 7 days from
baselining.

4) Format A3 with the General format; format A4 with the Text format.
Notice that A1 and A2 both look normal!

Can anyone tell me what is going on here? Any help in solving this mystery
would be greatly appreciated.

Thanks,
Bob