Merged cells

I am having problems with cells spanned several columns. I selected several
cells (A8 to J8) and merged them as one cell. I checked off 'word wrap' as
well but after I typed in a paragraph (all text), #'s appears in the cell. I
when I tried to print it, it prints the #'s instead of the text that I typed.

Could anyone shed some light? Any information is appreciated.

Thank you in advance.

I've seen this problem before, but not sure what causes it. Try changing
your cell format to General, then back to Text. That usually clears it up
for me.

HTH,
Elkar


"Rena" wrote:

> I am having problems with cells spanned several columns. I selected several
> cells (A8 to J8) and merged them as one cell. I checked off 'word wrap' as
> well but after I typed in a paragraph (all text), #'s appears in the cell. I
> when I tried to print it, it prints the #'s instead of the text that I typed.
>
> Could anyone shed some light? Any information is appreciated.
>
> Thank you in advance.

Thanks Elkar!
It was the format of the cell. I tried General and then back to Text but it
still did not display correctly. I changed to General and now it works. I
guess it was assuming that the field was numerics. Thanks for your help.

"Elkar" wrote:

> I've seen this problem before, but not sure what causes it. Try changing
> your cell format to General, then back to Text. That usually clears it up
> for me.
>
> HTH,
> Elkar
>
>
> "Rena" wrote:
>
> > I am having problems with cells spanned several columns. I selected several
> > cells (A8 to J8) and merged them as one cell. I checked off 'word wrap' as
> > well but after I typed in a paragraph (all text), #'s appears in the cell. I
> > when I tried to print it, it prints the #'s instead of the text that I typed.
> >
> > Could anyone shed some light? Any information is appreciated.
> >
> > Thank you in advance.

the # appears as the length of the text data you have entered has exceeded
255 characters. thats the maximum length it will take. try breaking it into
multiple cells.

Hope this solves your problem.


"Rena" wrote:

> I am having problems with cells spanned several columns. I selected several
> cells (A8 to J8) and merged them as one cell. I checked off 'word wrap' as
> well but after I typed in a paragraph (all text), #'s appears in the cell. I
> when I tried to print it, it prints the #'s instead of the text that I typed.
>
> Could anyone shed some light? Any information is appreciated.
>
> Thank you in advance.

In xl97+, each cell can contain almost 32k characters. xl95 was the last
version that supported only 255 characters per cell.

But excel does have a problem with cells formatted as text when the length of
the string in the cell is between 255 and 1024. Excel will show ###'s.
Formatting that cell as General will fix the problem.



Manoj wrote:
>
> the # appears as the length of the text data you have entered has exceeded
> 255 characters. thats the maximum length it will take. try breaking it into
> multiple cells.
>
> Hope this solves your problem.
>
> "Rena" wrote:
>
> > I am having problems with cells spanned several columns. I selected several
> > cells (A8 to J8) and merged them as one cell. I checked off 'word wrap' as
> > well but after I typed in a paragraph (all text), #'s appears in the cell. I
> > when I tried to print it, it prints the #'s instead of the text that I typed.
> >
> > Could anyone shed some light? Any information is appreciated.
> >
> > Thank you in advance.

--

Dave Peterson