| Thread | Last Post | Replies |
|
| Matching problem, trying again | 20 Apr 2007 01:00 GMT | 10 |
I have this worksheet where I have items in the third column that match up with items from the second column corresponding to the tenth increment decimal numbers in the first column. In the example below, the first 3 numbers in the third column match up with numbers in the
|
| Change 60 minutes to 1 hour | 19 Apr 2007 22:46 GMT | 1 |
I have a worksheet with a several fields that I place in minutes on projects. I need to total up the mintues to relect hours. For example:
|
| Entering Text and Date | 19 Apr 2007 22:22 GMT | 2 |
I need a macro that will enter some text "Uploaded" and the date and time in this format "The text" date time such as Uploaded 04/19/07 12:42 PM. I don't want this time to change after it is entered" Can any one help?
|
| Data Validation | 19 Apr 2007 21:48 GMT | 1 |
In excel I want to validate a cell where no more than 14 digits should be entered. And I want another cell to be validated to be entered as text only and any number should be restricted? Please help me with this. Not sure how to do it.
|
| Save | 19 Apr 2007 21:24 GMT | 2 |
I have a activeworkbook.save command as stated in a previous post but I'm not quite happy with it... Basically it takes too long to save. I'm usuing an old PC and it takes about 3 seconds to save. However if I only have the speadsheet open
|
| Using the EXACT Function | 19 Apr 2007 21:04 GMT | 4 |
I've created a simple spreadsheet. Column A is a list of 15034 used Work Order reference numbers (many values are missing); Column C is a complete list (25,000 numbers). I want to get a separate list of unused numbers, but can't get the EXACT
|
| Exact function | 19 Apr 2007 20:50 GMT | 3 |
I've created a simple spreadsheet. Column A is a list of 15,034 used Work Order reference numbers (many values are missing); Column C is a complete list (25,000 WO numbers).
|
| i can't figure out how to calculate percentages in excel | 19 Apr 2007 20:39 GMT | 4 |
I can't seem to get excel to show my the right numbers in percent format i'm dividing a cell of 3000 by a cell of 342 and i get 8.771929825. if i try to switch this to percentages i get 877%. what am i doing wrong?
|
| Time | 19 Apr 2007 19:52 GMT | 5 |
I am having a problem with calculating time. I can calculate the difference in hours over midnight, but what I can't do is not get a value to appear when I have only put in one number...For instance. I put in the time I start, and in my hours it shows midnight minus those ...
|
| Macro to remove last 4 characters from the contents of a cell. | 19 Apr 2007 19:52 GMT | 1 |
We need to come up with a way to remove the last 4 characters from the contents of a cell. I tried a macro, but wasn't sure how to make it go to the next cell. For example, I select a cell, press end, backspace 4 positions and then hit enter. Works great for 1 cell! Is there a ...
|
| summing data on months | 19 Apr 2007 18:50 GMT | 1 |
I have spreadsheet, in which col A has supplier name, Col B has year, Col C has Months and Col D has number of units supplied by the supplier. Now to calculate the number of units received for Month of Mar-06, i
|
| how to append text to the end of a row | 19 Apr 2007 17:54 GMT | 1 |
I have to batch rename a few thousand images that are named something like 1-1234-1111-1.jpg A program I have can rename using a csv file with 2 columns originalname;newname
|
| Get the list of external links | 19 Apr 2007 17:05 GMT | 1 |
Is there any way to get the list of external links referred by a workbook? Normally, we get this list by using Edit->Links in Microsoft excel. But I want to know the list of external links by programmatically. Thanks in advance.
|
| importing from Quatro Pro 8 | 19 Apr 2007 17:00 GMT | 1 |
I have windows xp and files in quatro pro 8 that I am trying to import into Excel 2007 it says invalid when I try and the only converter I can find is for windows 2000
|
| Custom format to divide cells by 100 | 19 Apr 2007 16:38 GMT | 2 |
Is there a way to set up a custom format that will divide numerical data by 100? I do not want to edit the fixed decimals option under Tools > Options
> Edit tab, as this will change all the cells in the workbook. Nor do |