format default spreadsheet to text
 

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.

format default spreadsheet to text
 

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.

format default spreadsheet to text
 

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

On Wed, 30 Apr 2008 01:39:00 -0700, 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.

format default spreadsheet to text
 

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" wrote:

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

On Wed, 30 Apr 2008 01:39:00 -0700, 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.

format default spreadsheet to text
 

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 ToolsAdd-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

On Thu, 1 May 2008 06:24:18 -0700, DD wrote:

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" wrote:

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

On Wed, 30 Apr 2008 01:39:00 -0700, 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.

format default spreadsheet to text
 

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




"Gord Dibben" wrote:

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 ToolsAdd-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

On Thu, 1 May 2008 06:24:18 -0700, DD wrote:

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" wrote:

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

On Wed, 30 Apr 2008 01:39:00 -0700, 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.

format default spreadsheet to text
 

problem solved after create the new profile.

"Gord Dibben" wrote:

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 ToolsAdd-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

On Thu, 1 May 2008 06:24:18 -0700, DD wrote:

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" wrote:

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

On Wed, 30 Apr 2008 01:39:00 -0700, 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.

format default spreadsheet to text
 

Thanks for letting us and google archives know the fix.

Gord

On Fri, 2 May 2008 01:03:00 -0700, DD wrote:

problem solved after create the new profile.

"Gord Dibben" wrote:

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 ToolsAdd-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

On Thu, 1 May 2008 06:24:18 -0700, DD wrote:

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" wrote:

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

On Wed, 30 Apr 2008 01:39:00 -0700, 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.