| Thread | Last Post | Replies |
|
| Merging | 30 Nov 2005 22:58 GMT | 3 |
We are trying to figure out how to merge 3 cells by using the following formula: =A1&", "&B1", "&C1 for example. So far it only seems to work for merging 2 cells. Would this be the proper formula for merging 3 cells or are we doing something wrong? Thank you for your help!
|
| Compile error on open | 30 Nov 2005 19:27 GMT | 1 |
We have a user who has experienced this error in excel 97 running on windows XP Professional. This error popped up 4 times when Open or close any excel file. “Compile error in hidden module NT Reg Code.”
|
| Excel 2002 Error in Conditional Formatting with Relative Addresses | 30 Nov 2005 13:17 GMT | 1 |
I recently switched from Excel 2000 to 2002 and have encountered a problem with Conditional Formatting. I have a number of spreadsheets with tables where cells have conditional formats based on a condition that contains a relative row address such as the following in Cell B372
|
| why are input values changed by Excel | 30 Nov 2005 13:08 GMT | 3 |
When I enter a value in Excel, the program automatically divides it by 10,000. This is not a formatting issue...the value is actually reduced and appears as the reduced value in the formula bar. Can anyone help with this please?
|
| Excel - restore ability to highlight cells and tell me sum | 29 Nov 2005 20:19 GMT | 3 |
Usually Excel lets you highlight a series of cells with numerical data and will sum the numbers leaving the total in the task bar. I accidentally turned it off and can't get it back on. I really need this feature. Re-installing the software did not help
|
| solver missing | 26 Nov 2005 21:25 GMT | 1 |
I'm working in Excel and have loaded the solver feature. I have it selected under add-ins, but it does not show up in the Tools menu. I did a repair of my installation, and everything looks fine. I just can't find it. I also don't seem to have access to the analysis pack. ...
|
| Why are my number entries multiplied by 1000? | 26 Nov 2005 01:29 GMT | 4 |
I am working with a workbook that I have been using succesfully for three years, several times per year. Now, after I enter a number into a cell formatted for "General," "Number," "Currency," or "Accounting," that entry is multiplied by 1000 when I tab out of the cell. This ...
|
| Excel Chart Guide | 25 Nov 2005 13:19 GMT | 2 |
The Thomson Learning company has a book on Office 2000, professional edition written by Beskeen, Friedrichsen,Reding and Swanson. When I use their "default" text "Chamber Statistics"(Integration A-8) with the Chart Guide in Excel a number of dates between 1909 and 2000 are ...
|
| no more font can be added to this worksheet | 24 Nov 2005 08:20 GMT | 1 |
I have been using excel to creat a number of graphs, now when I am trying to change the format of the graphs and box appears saying "no more fonts can be added to this work sheet" All i am trying to do is change the x and y naming
|
| Error message trying to open an Excel file | 23 Nov 2005 11:54 GMT | 1 |
Getting 'File Format is not valid' when opening an Excel file. Is it recoverable in any way
|
| Excel anomaly? | 22 Nov 2005 23:22 GMT | 2 |
Working with some data I came across some weird results: Starting with a value of 33.665, I subtracted 33.95, which gave me a value of -0.285. To normalize this I added 0.285 which resulted in a value of -3.7E-15????? I began checking the values and found that after I subtracted ...
|
| Excel won't open but Word can read | 21 Nov 2005 22:25 GMT | 2 |
I have Office XP professional, all updates are current. After finishing a mail merge document on my Word program, I now cannot open my workbook in Excel. I receive the error message "file format is not valid." I have gone back into Word and it can still read all the data.
|
| print page format problems | 20 Nov 2005 21:26 GMT | 2 |
I'm having problems where all of a sudden my page formatting gets screwed up. I have had some large spreadsheets that I have formatted to print on, say 6 pages. All of a sudden you try to print and it says 230 pages printing. You look back and see only a cell or 2 in printing ...
|
| Excel Formula calculations | 20 Nov 2005 20:24 GMT | 4 |
In a complex workbook, a simple formula on sheet 1 (='sheet2'!A3/1000) does not show the correct number. A search does not find the number anywhere in the workbook! sheet2 A3 is a sumif formula referring to yet another sheet in the workbook
|
| error "not in a recognizable format" | 20 Nov 2005 20:21 GMT | 1 |
Your worst nightmare. All of a sudden when I try to open any of my excel 2003 workbooks I get this message-- "This file is not in a recognizable format." All my files were created in excel2003. Nothing fancy and no links or imported data. What happened and how do I fix this. ...
|