| Thread | Last Post | Replies |
|
| A help please | 29 Oct 2006 09:20 GMT | 3 |
I have two columns A and B. Each row of Column A has text type data and each row of Column B has integer number or empty cell. Each of them related. The idea to do is that how to join each row from column A with empty cells
|
| How do I count workdays using an excel formula? | 29 Oct 2006 08:55 GMT | 10 |
I have a spreadsheet where I manually count the number of workdays in a given month, then I multiply those days by 8 hours. This tells me how many hours I've worked that month over or under the expected amount. For the last few years I've manually counted the number of work days ...
|
| Why does Excel always try to access the internet | 29 Oct 2006 01:54 GMT | 3 |
Every time Excel starts it tries to access the internet. I am not running any macros on startup and I see no reason it should try to access the internet. Does any one know what it is doing during these accesses? Thanks.
|
| Named Ranges in Formulas | 28 Oct 2006 23:42 GMT | 2 |
I have a worksheet with four columns - Total Hours Percent to total Hours Value of Hours
|
| rescaling one axis in a surface plot | 28 Oct 2006 22:42 GMT | 2 |
Is it possible to rescale one of the axes on a surface plot? Sometimes the automatic scale that Excel chooses is a bit silly and I end up with a very thin surface. Many thanks.
|
| linking cells | 28 Oct 2006 20:47 GMT | 2 |
I am trying to link cells from a column in workbook 1 to a column in workbook 2. (office 2003, winxp) I choose my destination row, put the '=' in the formula bar, copy the source row, and I see the formula in the formula bar but when I hit
|
| ? avoid changing sum function as rows added? | 28 Oct 2006 20:37 GMT | 4 |
Hello Group: I'm obviously new. To keep it simple, here's how I'll pose the question: Suppose I have multiple rows and two columns.
|
| How do I make 1 = "yes"? | 28 Oct 2006 20:24 GMT | 6 |
I have looked all over and have to finish this report asap. Help is not helping. How do I format a cell to return a word when I input a number? For example, "2" = "Not enough info" or "0" = "No"? Thanks -
|
| How to update dating? | 28 Oct 2006 20:09 GMT | 1 |
I currently use Office 2003 including most of excel sheets. But I still the old excel templates (e.g., invoice, purchasing order, etc) from 97office excel on 03Excel program. The old templates has our company logo and it automatically updated to the current date. It no ...
|
| can a cell auto update? | 28 Oct 2006 18:16 GMT | 3 |
Is it possible to have a cell update to the current date when ever you save a change to a file?
|
| Converting Excel to PDF? | 28 Oct 2006 18:14 GMT | 8 |
I have a huge text (several hundred pages) of Turkish in Excel format. Since some special characters are being dropped or altered when printing the Excel file, I need to convert the file into PDF to get a proper printout. Unfortunately, I am only able to convert on a page per ...
|
| graphics scale minimum | 28 Oct 2006 16:35 GMT | 2 |
I'm creating a horizontal bar chart. The horizontal axis is a date, and I want the minimum of the axis to be todays date TODAY() , and the maximum to be 30 days ahead. I know how to do this manually, by enterinng the dates via the 'scale'
|
| Extendinf conditional formatting to adjacent cells | 28 Oct 2006 15:54 GMT | 3 |
Is there a way to extend the conditional formatting on a cell to other cells? I have a list of transactions with Date Purchased | Description | Cost | Status.
|
| Intellisense Not Working | 28 Oct 2006 13:40 GMT | 1 |
Does Intellisense work for: ActiveDocument.BuiltInDocumentProperties ActiveDocument.CustomBuiltInDocumentProperties It doesn't for me.
|
| match rows from spreadsheets-Please help. | 28 Oct 2006 11:52 GMT | 7 |
how do i match rows from different spreadsheets to a directory: Directory ZIP No. 80001 1
|