Click on the box at the intersection of the row and column identifiers
in order to select the whole sheet, then click on Format | Cells |
Number tab, then select Text and OK.

Hope this helps.

Pete

On Apr 30, 9:39*am, DD wrote:
how to format the entire spreadsheet to Text by default .

the default now is general under the - fomart cells , category.

Having problem when we type a,b c character , it will hang the excel
applicatin

so I have to format the entire spreadsheet to text every time i use the
excel so that it will not hang the excel application.