| Thread | Last Post | Replies |
|
| Link question.... | 31 Dec 2004 22:29 GMT | 2 |
How can I keep email addresses I type into Excel from turning into blue links? I'm using a file just to archive things, and I'd rather have them show as ordinary text rather than links. I could not find an answer in the Excel help files.
|
| Q: Nested if | 31 Dec 2004 21:17 GMT | 2 |
Is it possible to create a nested if statment in excel? Thanks, Jim.
|
| Excels 97 sr-2 where? | 31 Dec 2004 21:09 GMT | 4 |
I have been attempting to install excel 97 Text Export update and receive a message requiring me to install Excel 97 SR-2! Where can I find this program/update for Excel 97
|
| Finding Values in a "Matrix" | 31 Dec 2004 20:21 GMT | 8 |
I have a matrix I have created in Excel. I am using this for correlations. I have cells B1 through G1 filled with text names (the same values as A2 through A7). In the matrix fields I calulate their correlations. In a seperate field, say J1, I am calculating the highest ...
|
| Formula for time? | 31 Dec 2004 20:13 GMT | 11 |
I am trying to create a spreadsheet that calculates difference in times. however if I have someone come in early it says in the box ###Num###. Ex.. Clocked In Time of Run
|
| Formulas not calculating??? | 31 Dec 2004 19:48 GMT | 1 |
My excel is no longer calculating formulas, when referencing other cells. How can I correct this?
|
| Excel Files Won't Open From Shortcut | 31 Dec 2004 18:25 GMT | 5 |
The title's misleading but I couldn't find a way to express it succinctly. If I have 2 Excel windows open, with one or more workbooks within each window, and I click on an Excel file-name in Windows Explorer or on a shortcut to an Excel file-name, nothing happens. If I close ...
|
| Cursor after RETURN | 31 Dec 2004 16:23 GMT | 2 |
Is it possible to stop the cursor moving down one cell after hitting <ENTER>?
|
| Excel 5.0 | 31 Dec 2004 16:15 GMT | 2 |
I need some help. I have been a faithful user of version 5.0 and I missed my opportunity to upgrade easily. Is there anyone who would be willing to part with an intermediate version so I can make the jump. I understand I need at least an Excel 97. I believe 97 can convert 5.0 ...
|
| EXcluding Zeros from the average in a row | 31 Dec 2004 16:08 GMT | 4 |
I am trying to average a row of numbers (F35:U35) that have numeric zeros in some of the cells. However, I would like to exclude them, and the cells from the calculation "=AVERAGE(F35:U35)". Is there a way to do that? Thanks
|
| Code not working and can't see why | 31 Dec 2004 15:13 GMT | 3 |
I have the code below attached to a command button (GoButton) on a worksheet called "Main". For some reason, the code shuts down and wants to debug any line with 'Range...' in it. Does anyone know why? Private Sub GoButton_Click()
|
| If cell is Bold then 1, if cell is Italics then 2? | 31 Dec 2004 14:52 GMT | 3 |
I have a list of hundreds of cells, the cells are either Bold, Italics, or Regular. I want those cells that are bold to result in 1 in another column. those in italics to will result in 2.
|
| How do I import data from Microsoft Project 2003 to Excel? | 31 Dec 2004 13:07 GMT | 3 |
I need information on whether or not I can import table data from Project 2003 to an Excel 2003 Worksheet?
|
| Save As style | 31 Dec 2004 12:25 GMT | 1 |
I run every day a workbook and I need to save it (using a macro) with name, the date value, e.g. 20041231.xls I can do that? Which is the syntax for this macro?
|
| how do I remove spaces from cells that were pasted | 31 Dec 2004 07:40 GMT | 1 |
I am pasting numbers into a spreadsheet, however its treating them as text because there is a space before the number. How do I remove the space so it treats it as a number ? I have used the =trim() function and its not working. Thanks for any help !
|