| Thread | Last Post | Replies |
|
| Worksheet Functions | 13 Jun 2005 17:21 GMT | 3 |
Can anyone PLEASE HELP me? How do I create a formula that will add a late fee according to the date? Here is how the spreadsheet is setup c=amount paid
|
| "COUNTIF" with times | 13 Jun 2005 16:30 GMT | 1 |
I have three column of times formatted "13:30". The third column is the result of subtracting the first two. I would like to find how many of the values in the third column are less than one hour or "<1:00". I tried to use
|
| Substitute each instance of "B"in a range with value in Col A | 13 Jun 2005 16:11 GMT | 5 |
need to substitute each instance of "B" in a range B4..g24 with the value in the Corresponding row, Col A.
 Signature Al
|
| excel 2003 - printing multiple worsheet splits 1 printjob in 2 | 13 Jun 2005 14:47 GMT | 4 |
I've got a problem with excel 2003. When I select some sheets to print them in 1 print job, it splits the printjob to 2 seperate printjobs. This normaly is not a problem, but since I want to print to pdf, pdf-printer will regerate 2 files.
|
| Reducing the size of a woorsheet | 13 Jun 2005 13:06 GMT | 3 |
I have been given a sheet with 200 rows. Rows 10 through 200 are identical. The print area is rows 1 through 30. I want to delete rows 31 through 200 so that it may be used in another
|
| copy/paste vaules, not formulas | 13 Jun 2005 13:03 GMT | 5 |
Is there an easier way to copy and paste the values of a cell without using notepad? When i paste directly to new column the formulas get copied--i only want to paste the final values... Makes sense?
|
| File, Edit, View etc. (pull down menus) have disappeared | 13 Jun 2005 12:45 GMT | 2 |
All my pull-down menus in the top have suddently disappeared and I have no idea how nor how to get them back. Can anybody help me?
|
| Excel stop | 13 Jun 2005 12:07 GMT | 1 |
I have stop errors in stations whith office 2000, excel's whith links to reuters or bllomberg applications. Any idea?
|
| How can I paste text without changing the font. | 13 Jun 2005 11:37 GMT | 3 |
Can I post a link or just some text I have cut from the web and have Excel keep the default font?
|
| how to use a VLOOKUP function in a VBA code? | 13 Jun 2005 09:27 GMT | 3 |
Hi am a novice in excel...i have a excel sheet with 2 columns with around 10000 records.i have placed a button in the excel sheet and on clicking the button it should find all the values in the first column which doesnt have a match
|
| Drag and drop | 13 Jun 2005 09:06 GMT | 2 |
I have a set of input data in (say) A2 to A4. Formula in A5 and A6 and input data in A7 to A9. Rows 5 and 6 is hidden. Row numbers and column headings are also hidden. The user types data into A2 and then drags to A9, in this process he
|
| Make Cell Look like Textbox | 13 Jun 2005 05:17 GMT | 5 |
I'd like to have a spreadsheet cell look like a textbox on a windows form. The textboxes will be perpendicular and adjacent to each other. No cells between cells. Essentially I'm trying to add padding to a the cell border. So each
|
| India's and China's Date & Time | 13 Jun 2005 05:04 GMT | 6 |
I need India's and China's current day and time (if it's ahead one day or later, as well as time difference) in relation to California's current day and time. (including daylight savings time). I want to be able to automatically show California's current time and
|
| auto date | 13 Jun 2005 01:25 GMT | 2 |
Can someone tell me how to turn off the auto date part of excel? I need to insert different dates but everytime I try to input a date such as 6/02, 06/02, June 02, it always changes it to 6-05, 06-05, June-05. Any time I try any year after 2000 it does this.
|
| Viewers for Excel files | 13 Jun 2005 01:20 GMT | 3 |
Does anyone know where I can find a download of an Excel viewer that will operate on the Windows 98 operating system? Thanks, JWD
|