| Thread | Last Post | Replies |
|
| Stocks | 11 Aug 2006 06:08 GMT | 1 |
Im new to excel. I do some stock trading, when I report my Income/Profit to the IRS for taxes, I am asked for my Cost. Is FIFO the correct method to calculate cost? if so, whats the best way to implement such a method
|
| Problem Calculating Various Month Totals ?? | 11 Aug 2006 05:58 GMT | 3 |
I need a formula that will SUM values for particular Months within column (B4:B1000)... I am trying to use a formula that will identify the first 3 letters o the month and then add the currency (G4:G1000) for those months only..
|
| vlookup and max ? | 11 Aug 2006 03:54 GMT | 2 |
I want to get the max # from a worksheet with multiple rows of my key value. WM-DV028 Windows WDW 25 3/29/2006 WM-DV028 Windows WDW 25 3/30/2006 WM-DV028 Windows WDW 8 3/31/2006
|
| Decimal to feet/inch/fractional inch conversion | 11 Aug 2006 03:44 GMT | 1 |
Is there a way that a cell can be formatted to convert a decimal of a foot (2.78') to feet/inches format (2'-9 3/8")?
|
| Why can't I insert a row in my worksheet? | 11 Aug 2006 03:32 GMT | 9 |
I am trying to insert a row of simple data into my worksheet. When I do, I get the following message: "This operation is not allowed. The operation is attempting to shift cells in a list on your worksheet."
|
| OLE: Excel.Application | 11 Aug 2006 02:33 GMT | 2 |
in VB.Net, I use Excel to display results : dim xl as new Excel.Application // creates an Excel process // snip (putting values into cells) xl.Visible = true
|
| Help With Pivots | 11 Aug 2006 01:47 GMT | 1 |
I have the following data: PolicyNumber ReceivedTransDate TimeToIssue 0-15 16-30 31-45 45+ 45454544 1/4/2006 0 1 0 0 0 67676766 1/4/2006 0 1 0 0 0
|
| Pivot Table / Format cells | 11 Aug 2006 01:43 GMT | 1 |
I am setting up a pivot table at the moment, and part of my source dat is formatted at percentage. In the pivot table it shows the data as 0. instead of 60%. I found out how to format the cell, by rightclicking it and going t
|
| Printing problem in Excel | 11 Aug 2006 01:06 GMT | 3 |
I just started having this curious problem yesterday. I have Win2k with Office2000. I made a couple of minor edits to one of the worksheets in a 9 sheet workbook (formatted cells to have strikethroughs, changed a sum formula). Now, when I print preview the worksheet has shrunk
|
| Date formatting in footer | 11 Aug 2006 01:02 GMT | 1 |
How do I change the format of the date option in the footer of a worksheet? For example, currently it shows 8/9/06; how would I change it to Aug 8, 2006 or 9 Aug 2006 for example?. TIA
|
| Copy data in multiple worksheets | 11 Aug 2006 00:18 GMT | 2 |
How do I put the total of a row(column) of numbers from one worksheet to another worksheet? Mahalo. Karen
|
| Adding row without messing things up. | 10 Aug 2006 23:56 GMT | 1 |
If I have 9 rows of data and then a row 10 containing formulas, is i possible to add another row of data after row9 and have the formula ro move automatically to row 11 without having to copy and paste it Thanks alot
|
| putting 2 charts on 1 sheet. | 10 Aug 2006 23:26 GMT | 1 |
In Excel 2003, it is possible to copy a chart from 1 worksheet and paste on a worksheet that already has a chart? It doesn't seem to want to work right for me. One pastes over the other one. I'm thinking because the sheets that the charts are on originally were created for ...
|
| How do I create a spreadsheet? | 10 Aug 2006 23:26 GMT | 4 |
I need create a simple spreadsheet. To show the total number of tasks that was comlpeted that week. Can you help me?
|
| spreadsheet | 10 Aug 2006 22:45 GMT | 3 |
I'm making a spreadsheet and would like to keep the lines when I print it. How do I do this. Thank you
|