How do I prevent values being shown as # in excel

I have a cell which 开发者_如何学JAVAis formatted as Text field with wrap text on. The values are shown as "#" when I move away from the cell, how do I prevent it?

Try to expand the column size (width). If this doesn't help try to format the cell as General instead of Text.

When this happens to me I just have to expand the column size so that the content fits perfectly within the cell.

More about it here:

Excel - #### sign in cell formatted "Wrap Text"