cell shows like ################# but when I edit the cell I am able to
complete text information (combination of text and number). I would like to
retain complete entries in the cell.

Please let me know if I need to make some formatting changes.

Thanks in advance.