Text does not need to be explicitly formatted as Text and in fact, if you do format the cell as Text and the text is between 255 and 1024 characters long, the cell will display ###### as you found (longer or shorter will display OK).
If you copy and paste from the internet you will get all sorts of interesting characters in the text like chr(160) (a non-breaking space).