Hi,
I have an Excel sheet with a comment box, which is nothing but 9 rows and 10 columns of cells being merged together with Word Wrap set on. This cell is of type Text. But when some of my users type in data, typically no of characters greater than 255 and less than 1025 and they tab out of the cell it becomes all ######. Is this because of the length of the text in the cell.
Can anyone tell what is going on? How can I fix this?
Thanks,
Nalini
Last edited by nals14; 09-07-2007 at 12:56 PM.
try increasing the with of the cell or decreasing the size of the text to see if this is your problem.
OK I just checked. I have merged 9 rows and 10 columns. So the cell is pretty big. It has word wrap on and is of type 'Text'. Once the number of characters is > 255 and < 1025 the text in the cell is displayed as #####. It doesn't matter if I merge more cells to form a bigger cell.
Any Ideas?
Change the format of the cell to General, instead of Text.
click on the column border at the top drag the width of your column ,make it wider
That doens't work in this particular instance.Originally Posted by daniel_d_n_r
Posting Permissions
Reply With Quote
