format default spreadsheet to text

[DD]

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.

 

[Pete_UK]

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

 

[Gord Dibben]

Formatting cells to text is not the answer to your problem.

It may be a workaround but you have something else happening.

I would be looking for why Excel hangs when you type in letters when cells are
formatted to General.

General is exactly that..........General............Excel should not barf when
you enter letters, numbers, dates or whatever.

Does this "hang" occur with every workbook/sheet?

Existing ones? New ones?


Gord Dibben MS Excel MVP

 

[DD]

YES, It hangs with every workbook and sheet , new & existing also hang.only
when format the shell to text then it not hang.


uninstalled & resintall does not help

 

[Gord Dibben]

I wouldn't know where to start with this one.

Existing workbooks could have some code attached but new workbooks could not
come under that situation.

Do you have any strange add-ins running when you open Excel?

Go into Tools>Add-ins and uncheck everything.

Close and re-start Excel. Still the same "hanging"?

If not, re-check each add-in one at a time until it hangs again.


Gord

 

[DD]

There is event id 1002 when the application hang
0000: 41 70 70 6c 69 63 61 74 Applicat
0008: 69 6f 6e 20 48 61 6e 67 ion Hang
0010: 20 20 45 58 43 45 4c 2e EXCEL.
0018: 45 58 45 20 37 2e 30 2e EXE 7.0.
0020: 30 2e 34 34 31 33 20 69 0.4413 i
0028: 6e 20 68 75 6e 67 61 70 n hungap
0030: 70 20 30 2e 30 2e 30 2e p 0.0.0.
0038: 30 20 61 74 20 6f 66 66 0 at off
0040: 73 65 74 20 30 30 30 30 set 0000
0048: 30 30 30 30 0000

 

[DD]

problem solved after create the new profile.

I wouldn't know where to start with this one.

Existing workbooks could have some code attached but new workbooks could not
come under that situation.

Do you have any strange add-ins running when you open Excel?

Go into Tools>Add-ins and uncheck everything.

Close and re-start Excel. Still the same "hanging"?

If not, re-check each add-in one at a time until it hangs again.


Gord

 

[Gord Dibben]

Thanks for letting us and google archives know the fix.

Gord