PDA

View Full Version : Cell contents become ###



nals14
09-07-2007, 10:53 AM
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?:think:

Thanks,
Nalini

Barryj
09-07-2007, 12:46 PM
try increasing the with of the cell or decreasing the size of the text to see if this is your problem.

nals14
09-07-2007, 12:55 PM
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.:think:

Any Ideas?

OdiN
09-07-2007, 01:43 PM
Change the format of the cell to General, instead of Text.

daniel_d_n_r
09-07-2007, 05:06 PM
click on the column border at the top drag the width of your column ,make it wider

OdiN
09-07-2007, 08:08 PM
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.