| Thread | Last Post | Replies |
|
| 3D Maps | 08 Sep 2007 10:48 GMT | 1 |
I have a 3D Surface Map. The X an Y axis are labeled 1 to 12 and S1 to S12. Is there a way to repalce these labels with something more relivant? Thanks in advance...
|
| pivot table help | 08 Sep 2007 07:44 GMT | 2 |
I have a pivot table with following fields: Product, Party, Qty, Rate, Amt Product, Party are row fields, Qty, Rate, Amt are Data fields Everything works fine in the pivot table, and Qty, Rate and Amt have
|
| copy partial worksheet to a different worksheet based on date?? | 08 Sep 2007 07:01 GMT | 4 |
The subject says it all?? How do I copy information from one worksheet to another based on a date? I have a worksheet which I am keeping a list of equipment, date bought, what it is, how much it cost, chargeable or not and where it was bought
|
| Calculation accuracy | 08 Sep 2007 02:13 GMT | 1 |
When i tried calculating a simple math, i found a rounding issue in excel: I made the following computation by having each value in a cell and inputed formula to compute the answer: A1 = 19978.39
|
| how to add ( and ) when using function sum | 08 Sep 2007 00:53 GMT | 7 |
want to add 1+2+3 = (6) how do to it?
|
| . | 07 Sep 2007 23:19 GMT | 1 |
|
| what happened to the insert = at the left of the formula bar? | 07 Sep 2007 20:56 GMT | 1 |
I am new to Excel 2007 and miss the ability to click the = that used to be in the box at the left of the formula bar. It would put the beginning = in so that a formula could be entered directly by clicking on the first cell, entering an operator and clicking the second cell. ...
|
| Excel w/SQL 2000 | 07 Sep 2007 20:51 GMT | 3 |
I am considering installing Office 2007. I often work with and share exported data from SQL 2000 where the wizard offers an export to Excel 97-2000. I usually do some minor formatting before I shae the excel data, so the workbooks are saved in my current version of Excel at ...
|
| Column Heading Display | 07 Sep 2007 20:17 GMT | 1 |
All of a sudden, I have noticed that my column headings are 1,2,3, rather than A,B,C. How do I return them to A,B,C so that I can enter formulas?
|
| Tracking dates in Excel | 07 Sep 2007 18:56 GMT | 5 |
What would be the formula to do the following in Excel (2003)? Want to be able to enter a series of different start dates and then with a formula have Excel calculate a corresponding event date 3 months later, 6 months later, 9 months later, and 12 months later. It would be ...
|
| Extra quotes in CSV file (""") Help ! | 07 Sep 2007 18:41 GMT | 1 |
If I write a excel file that has a string as follows: ( 1,"ABC",2 ) the csv file contains ( 1,"""ABC""",2 ). How do I trun off the 2 extra ( " ). ??? FredCollinsIII@EarthLink.net
|
| Writing a Macro | 07 Sep 2007 18:03 GMT | 3 |
I'm trying to set up a macro on my payroll sheet that will calculate if FICA is due. Basically, I have a list of employees and I need to be able to account for those employees that cap out of FICA. Right now, I've got a YTD column (C), Employees (Rows 1-15), FICA (D). The ...
|
| filter only one column | 07 Sep 2007 18:03 GMT | 1 |
I want to filter only one column in my spreadsheet. I can seem to only filter all the columns in a row by going to Data, Filter, autofilter. But this makes me filter all the columns. I just want to filter one specific column so I don't see the filters on the other columns. ...
|
| Adding columns containing numbers with dashes | 07 Sep 2007 17:40 GMT | 6 |
I have several columns (formatted as text) containing numbers with dashes, i.e., 20-1 15-2
|
| table tool design tab is missing in Excel 2007 | 07 Sep 2007 17:06 GMT | 3 |
I am running MS Office Home and Student 2007 on Windows XP and am having issues with excel 2007. I believe there is suppose to be a tab titled 'table tools design' that appears when I click anywhere on the table.
|