| Thread | Last Post | Replies |
|
| Automatic Re-calc | 17 Jun 2007 12:13 GMT | 9 |
I'm running Excel XP, and all of a sudden my workbook uses manual calc. I go Tools --> options --> calculations and set it to Automatic. Next time I open the workbook, its back to Manual What am I doing wrong ???
|
| Saving dbf | 17 Jun 2007 11:19 GMT | 4 |
I am brand new to 2007 but have found I am unable to save a *.dbf file back to a program I was able to do with version 2003. Is there a way around it?
|
| making a list | 17 Jun 2007 09:09 GMT | 4 |
How can I get excel to look up a column, copy the data over to another worksheet, deleting all the duplicate names. So I have a nice list of names. Or some pointers would do.
|
| Help..Getting data from another spreadsheet | 17 Jun 2007 03:47 GMT | 1 |
I am tring to put together a stats book.I have the data imported through a query. However it's missing some important info so I went to another site a imported the other data into a differnt spreadsheet.
|
| Transfer specific characters from cell to another cell. | 17 Jun 2007 02:14 GMT | 3 |
Ok, I have this sheet that has 700 cells which includes name, last name of the person and his/her address in it. note: Name, last name and address are in the same cell. Now I would like to transfer JUST the names and last name to another cell.
|
| running avg formula that ignores blanks | 16 Jun 2007 23:48 GMT | 3 |
I am attempting to build a formula that averages a column of data (that gets added to every day), but ignores, or does not include blank rows. Any hints?
|
| In 3D ref. can non-contiguous sheets appear? | 16 Jun 2007 23:03 GMT | 2 |
I know that Sheet1:Sheet3!A1:F1 can be named. But Can I have Sheet1 & Sheet3 (excluding sheet2 ?) If so, what would be the notation? Thanks
|
| Format Cells, Text Alignment, Distributed | 16 Jun 2007 22:58 GMT | 2 |
I have a cell that I need to format so that it is justified but I need to control where the text breaks within the cell. For example, I have in cell A1 "Name: Jeff Willis Date: 6/16/2007". The cell width is fairly wide and I would like to format the cells Horizontal Text ...
|
| Time as a fraction | 16 Jun 2007 21:24 GMT | 2 |
Hi Group, I need to express total time as a fraction, for example Excel shaws the result of a time calculation as 8:30 which is eight hours and thirty minutes, I need to have it as 8 1/2 or 8.50 hours, is this possible? Many thanks for
|
| calculating | 16 Jun 2007 16:00 GMT | 2 |
My dear , can you tell me how to calculate values between two dates ( with example if is it possible) .
 Signature Message posted via OfficeKB.com
|
| Present Value of One Time Payment N Years in Future | 16 Jun 2007 15:55 GMT | 4 |
How do you calculate the present value of a one time payment that is N years in the future?
 Signature Will
|
| Reversing Legend Order | 16 Jun 2007 15:49 GMT | 1 |
I've just built a whisker & box chart by using the x-y scatterplot chart-type and connecting the plotted variables. The boxes are stacked vertically so I've put my legend to the right of the chart area. However, the legend is in the opposite order to the boxes.
|
| Absolute positioning not working; am I thinking about it wrong? | 16 Jun 2007 15:40 GMT | 5 |
I was under the impression that if one used the "$" in a cell reference, that would mean that whether or not columns and/or rows are inserted, the reference would remain at the ORIGINAL spot. So, for instance, if I put in cell C3 the following:
|
| Help needed | 16 Jun 2007 15:33 GMT | 5 |
Please Help me in the following :: For Example in Cell A1 I write (15860) Rupees '''Rupees is Pakistani Currency' now it should be divided into parts as under:::>
|
| Finding the first value equal to or less than 0 | 16 Jun 2007 06:13 GMT | 3 |
Basically i have hundreds of rows the top row has a date going out for many columns , so picture this 1/1 2/1 3/1 4/1 5/1 6/1
|