| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format & Default Format Help | Excel Discussion (Misc queries) | |||
| text format in spreadsheet cells | Excel Discussion (Misc queries) | |||
| can i change the default cell format to text in a new document | Excel Discussion (Misc queries) | |||
| Set default column data format in Excel to text NOT general | Setting up and Configuration of Excel | |||
| How to change default cell format to "Text" | Excel Discussion (Misc queries) | |||
Linear Mode
