Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merged cells
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merged cells
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merged cells
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merged cells
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy single cell into cell that is merged from two cells? | Excel Discussion (Misc queries) | |||
Linking Merged Cells | Excel Worksheet Functions | |||
merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
paste special | values should work with merged cells | Excel Discussion (Misc queries) |