| Thread | Last Post | Replies |
|
| Time conversion | 17 Feb 2007 11:55 GMT | 3 |
In A1 I have the value 60 I want it in 1:00:00 format What I do is, I divide that by A1/24*60 and the copy that and paste- special-value on A1 Is there any way to convert the number 60 into 1:00:00 format without
|
| Conditional Sums | 17 Feb 2007 08:22 GMT | 5 |
I have a table containing numerical values in column D and text in column E. The text in column E can be either S, M or P In cell D31 I want to total the values in column D corresponding to the
|
| Variations on different computers? | 17 Feb 2007 02:23 GMT | 3 |
A friend of mine developed a spreadsheet in Excel with all of the columns widths at 9.0. On his laptop all of the numbers are visible. However, when that spreadsheet is emailed and opened on a new computer, many of the larger numbers are not visible and have the ########.
|
| CountIf this... but also a date range? | 17 Feb 2007 01:35 GMT | 3 |
I'm a fairly light Excel user, which is why this is escaping me. I'm reporting on some data kept on one sheet. The first task was simple: out of a column, count the occurences of a certain value, based on a list of values already on the reporting page. That one's
|
| Copy Excel to Word - Multiple Pages | 17 Feb 2007 01:01 GMT | 1 |
How do I copy a multiple page Excel file into Word? Need to have the first row repeated on all pages. Have tried to do a copy, paste special but only one page shows in my Word document.
|
| recipe card program | 16 Feb 2007 23:20 GMT | 1 |
I have recipes loaded into windows data base (wdb) and had them converted to excel. I realized that excel 2003 doesn't have the same recipe program that wdb had and now I need a place to put those recipes. I see that word has a template but I don't know how to convert my already ...
|
| Shortcut that passes a password | 16 Feb 2007 21:57 GMT | 1 |
I have a spreadsheet that is on our network and I keep it password protected to keep the general staff out, but it's not overly sensitivity. Is there a way that I can put a shortcut on my system what will pass in the password so when I'm on my computer I don't have to enter the ...
|
| EXCEL Column Adjustment | 16 Feb 2007 21:52 GMT | 1 |
I'm not sure if this is possible, but any help would be great. I want to add two new columns in between every current column I have now. For example Current:
|
| Combining Spreadsheets On An On-going Basis | 16 Feb 2007 21:19 GMT | 5 |
We have been using for 5 years now a form in Excel called Problem Report. Every report is the same. The report number is in cell K3. The defect code is in cell L20 and so on. I have to summarize some of the fields and want to end up with a report like the following:
|
| Pop Up Window in Excel | 16 Feb 2007 21:01 GMT | 5 |
I am currently working on a project that would require a pop up window for a particular cell. Of course this would be done as a macros. The pop up would be required to occure whenever a particular cell is selected, wether by clicking it or tabing to it. The Pop Up would
|
| Excel Text Sorting? An Easy Solution | 16 Feb 2007 20:26 GMT | 2 |
I am trying to figure out a way in Excel to take all the text to the right of a "-" symbol and put it in a new column. For example; If I have a list of albums in column A such as: "Bob Dylan-The
|
| Ohm's Law | 16 Feb 2007 20:17 GMT | 9 |
I need to create a little sheet to calculate different aspects of Ohm's Law and I need some help to create formulas, please: B C D E F 5
|
| Stock List 2 | 16 Feb 2007 19:34 GMT | 2 |
I would like to make a column for orders on a stock list. Insert a quantity on that column for any of the items ( rows) I want to order and then print it out... BUT I only want to print the rows that have quantities in that column ( i.e. the actual items I am
|
| Stock list | 16 Feb 2007 19:25 GMT | 2 |
I have a stock list with a "quantity" column. What I would like to do is add the new stock(A) to the existing quantity(C) column or subtract requisitioned (B) items from the quantity column.(C)
|
| Thanks to all who answered my questions | 16 Feb 2007 17:57 GMT | 14 |
I want to thank you all for answering my questions. I guess I cant email a native Pocket Word of Excel file to someone without Active Sync, or in the case of Pocket Excel (to someone without a PocketPC). Yes I do have TextMaker office, but it does not allow password protecting ...
|