| Thread | Last Post | Replies |
|
| Difference In Time | 27 Apr 2005 21:51 GMT | 6 |
I have one colum that has the time(hour:minute:second) and cell underneath has a second time some seconds later. I need to find out the difference in time (in seconds) and place this value in a seperate cell. The cell underneath has a time, and I need to find the difference in ...
|
| Pivot Table Layout Question | 27 Apr 2005 20:53 GMT | 1 |
I have a pivot table question. My data fields are: Month, Employee, Project, Task, Hours_worked. I make a table using Month, Employee & Project as Rows and Sum of hours-worked as the Data. I would like to add a "%" column to the right of the Sum of hours-worked where the
|
| huge file size | 27 Apr 2005 19:56 GMT | 2 |
i have an excel file which is 15KB in size, but after doing some formating it becomes 15MB after saving it. What could be wrong here? thanks
|
| Help With VBA Macros | 27 Apr 2005 19:56 GMT | 3 |
I've created a spreadsheet that, when I try to save manually as a CS using a macro... it works, but the program that reads the CSV is no picking up the text within the CSV because it's reading the macr code.
|
| Count Unique Strings | 27 Apr 2005 19:44 GMT | 4 |
I am trying to count "unique" items and I have tried the different suggestions out there and itis still coming up incorrect. What I have: (These are text values, and have to remain that way.) 00000002756
|
| How do you remove a checkbox from an excel spreadsheet?? | 27 Apr 2005 18:17 GMT | 3 |
II am newbie to Excel and am trying to make changes to a form that has "checkboxes" and I would like to know how to delete them.
|
| edit formula bar in excel 2003? | 27 Apr 2005 18:10 GMT | 1 |
in excel 2000 there is a edit formula button that when clicked starts the formula and produces a edit formula bar.. I find this helpful because I put it just below the rows I am working on and keeps me on the row I am working on and from getting confused when selecting cells. ...
|
| maximum number of rows that can be coppied to clipboard | 27 Apr 2005 17:52 GMT | 4 |
is there a maximum number of rows that can be copied to clipboard from a table? using access 2002 on XP,
|
| the 'degree' symbol | 27 Apr 2005 17:34 GMT | 20 |
Does anyone have a good way of getting the 'degree' symbol into a series of cells? Either farenheit or celcius...doesn't matter...i just want the symbol. Dave French
|
| how to lock a single cell? | 27 Apr 2005 17:11 GMT | 1 |
I want to make only few cells read only. How? Many THANKS Has
|
| V Lookup 2nd Occurrence | 27 Apr 2005 17:07 GMT | 8 |
I was offered a solution to the above, and I think my son has loaded a copy of DragonBallZ over the file on a floppy. Apologies to the helpful person who replied. I have tried unsuccessfully to find the post on Google.
|
| format of cell | 27 Apr 2005 16:13 GMT | 4 |
I am trying to type in 2-26 in a cell, I have the cell as `general` format but it keeps jumping back to custom and giving 46413. Is there something else I should be doing? thanks
|
| An easier way to get the last word from a string ? | 27 Apr 2005 15:54 GMT | 3 |
Is there any way extract the last word from a string than this: =IF(ISERR(FIND(" ",TRIM(A1),1)),TRIM(A1),RIGHT(TRIM(A1),MATCH(" ",(MID(TRIM(A1),LEN(TRIM(A1))-ROW(INDIRECT("1:"&LEN(TRIM(A1))))+1,1)),0)-1)) Where A1 contains the string and the above needs to be entered as an array
|
| Couple more questions... | 27 Apr 2005 15:21 GMT | 1 |
ok, I'm cutting and pasting a column of numbers from a mainframe session and dropping them into excel. But, the numbers all change when I do it! I have to paste into notepad, then re-copy and then past into excel. Any ideas? Also, if I copy 2 columns of numbers, I'd like to be ...
|
| How do I display the RESULT of a formula | 27 Apr 2005 15:18 GMT | 3 |
I enter "=1+1" in a cell. Instead of displaying 2, what is displayed is "=1+1" (without the quotes). I go into microsoft help, do a search on "display formla", it has a section "display or hide formulas", it has "switch between displaying formulas and their values on a ...
|