| Thread | Last Post | Replies |
|
| Worksheet Function | 02 Mar 2008 03:08 GMT | 2 |
I have a worksheet that has the following information: Initials of an employee, new loans signed up and all the relevant information i.e. DJC 12345 50,000.00 MORTGAGE
|
| Scanning into Excel | 02 Mar 2008 01:51 GMT | 2 |
Recently, my hard drive died and I lost a lot of files. Is it possible to scan a printed Excel file into Excel? (I know...I should have backed it up!) thanks in advance
|
| excel - new windows | 02 Mar 2008 01:11 GMT | 4 |
when i click on an ecel file icon, the file is opened by excel. when i click on another excel icon, that file too is opened in excel but in the same instance as the first one. how can i set things up so that clicking on an excel icon opens the file in its own window (instance ...
|
| Excell 2000 / create a consecutive list of numbers | 02 Mar 2008 00:10 GMT | 4 |
I would like to be able to automatically fill a series of cells with consecutive numbers after entering the starting number in cell a1 for example. I would like the numbers to be filled in horizontally. I know I can do this with days of a week and calendar dates, but cannot ...
|
| macro to color top 10% in range | 01 Mar 2008 21:34 GMT | 4 |
Hello. I'm using Excel X (VBA5) and trying write a macro which will change the interior cell color of those cells whose value is in the top ten percent of the selected range of cells. I was able to do this quite easily with
|
| paste value vs type value (formula not working) | 01 Mar 2008 19:58 GMT | 1 |
I have a formula that works just fine, as long as i paste the values from the original list and not type the numbers in. There are no hidden spaces (that I know of), but when I type the same value that I have in my orignial list, the formula gives me an error
|
| Only allow 6 digits to be entered ina cell | 01 Mar 2008 18:15 GMT | 1 |
Coud someone tell me how I set a function in a cell to only allow 6 digit number to be entered in a cell. Thank you Roger
|
| wrong format for month in cell | 01 Mar 2008 18:12 GMT | 4 |
Using Excel 2003 on Windows XP Pro. sp2 I have a date in a cell like this 03/01/2008. let say cell B1 Under format cell; Category = Date , Type = *03/14/2008 In another cell I have a formula like this; =MONTH(B1)
|
| Where do I setup my spreadsheet for printing | 01 Mar 2008 17:40 GMT | 6 |
I gave Office 2007, where do I go to setup the page for printing, I have set the print area but cannot find where to setup for printing. I tried help but it did not help:- thanks
|
| Corrupted file | 01 Mar 2008 16:03 GMT | 3 |
I have a corrupted excel file that was password protected. Is there any way to recover something like this?
|
| sum by coding without 0 | 01 Mar 2008 15:52 GMT | 2 |
in the following program if there is no value in the cells a1 and b1 it returns 0 Public Sub Add2Cells() Range("C1").Value = Range("A1").Value + Range("B1").Value
|
| Too many macros | 01 Mar 2008 15:05 GMT | 5 |
In this spreadsheet for my golfing group, I have 45 macros and 45 buttons to run them. One macro & button per golfer. Is there a way to do the same thing with one macro and one button where I would merely place the cursor in the proper name cell and then click the button?
|
| Optimization challenge | 01 Mar 2008 14:41 GMT | 1 |
I have a cycling management game in which cyclists (column A) score points (column B) and cost money (column C). After every stage I want to know what the ultimate team of 10 point scoring cyclists is with the constraint that
|
| Pivot Table Help | 01 Mar 2008 14:37 GMT | 1 |
Is there any way that I can change the source data range after the pivot table has been created, without having to do a new sheet. I.e. Curent range is A1:D25 Want to amend to A1: F1000
|
| Exact number of digits in a cell | 01 Mar 2008 14:25 GMT | 1 |
Sorry to post simple question in this forum but I need to use a function key to check if the correct number of digits are in a cell. I presume it would work such as 6 digits entered True, 4 or 7 False. I have tried a number of books but am struggling a little. Help very much ...
|