| Thread | Last Post | Replies |
|
| Why doesn't this work?? | 30 Sep 2007 14:45 GMT | 4 |
when I type in one cell 1 and the the cell below it 2 then highlight both and drag the corner the next cell will be then 4 then 5 and so on BUT when I have cells that have this pimage_379.jpg
|
| inputting figures in cells | 30 Sep 2007 13:38 GMT | 1 |
Hi hope you can help. I have recently got excel07 on the vista premium platform. I dont know what I have done, but when i input a number in any cell for example 102 the cell show 1.02 The only way i can get around it is by
|
| Why doesn't this work?? | 30 Sep 2007 12:34 GMT | 1 |
when I type in one cell 1 and the the cell below it 2 then highlight both and drag the corner the next cell will be then 4 then 5 and so on BUT when I have cells that have this pimage_379.jpg
|
| calculation accuracy | 30 Sep 2007 09:42 GMT | 3 |
Hi friends, I have a simple question about calculation accuracy (excel 2002) that drives me crazy: just enter in A1 value 388
|
| Excel 2007 Arithmetic | 30 Sep 2007 09:28 GMT | 5 |
Hello, All! According to http://www.msnbc.msn.com/id/21033161/ it looks like Excel is having trouble either displaying or using 2^16. I'd really like to see the sloppy code that causes this!
|
| Average Every Second Column | 30 Sep 2007 06:36 GMT | 15 |
I was wondering if it's possible to get an average from every second column listed below? C8, E8, G8, I8, K8 M8, O8, Q8, R8, T8, V8, X8, Z8, AB8, AD8, AF8, AH8, AJ8 Thanks
|
| Inserting line breaks in text formula | 30 Sep 2007 06:31 GMT | 6 |
I'm trying to insert a line break in a cell that has a formula that joins (using "&") text from other cells. I have cells for address, city, and zip and would like to create a new cell that has them all joined, but with line breaks.
|
| Array formula | 30 Sep 2007 06:26 GMT | 4 |
I am using this formula to multiply all the digits in an integer: =PRODUCT(VALUE(MID(C55,ROW(A1:OFFSET(A1,LEN(C55)-1,0)),1))) So far so good... But I want to copy this array formula for a large range of cells, each
|
| Merging worksheets together | 30 Sep 2007 06:08 GMT | 1 |
I am trying to merge two worksheets together. my first page has customer names,address,phone number, city, country. The second page has each person's order they have made. What i want to do is. On page one, if i double click John Doe, I want all of
|
| how to turn automatically in CAPITALS parts of text in excel ? | 30 Sep 2007 03:50 GMT | 3 |
I have a huge catalogue of music (thousands of records) made in excel where I have in the first cell the name of the band + album + format, something like this: Pearl Jam - name of the album - CD
|
| Excel probability distributions | 30 Sep 2007 03:43 GMT | 8 |
My apologies if this is more an "academic" question than an Excel question... I'm looking to create a probability distribution in Excel. My probability distribution is similar to a normal distribution, but it's scewed. My data ranges (for example) from 200 to 800 and has a mean ...
|
| Turn off automatic date formatting | 30 Sep 2007 03:13 GMT | 4 |
I'm pasting data into an Excel spreadsheet which is formatted as W-L-T, i.e. 1-0-2. Excel very handily insists that I'm trying to paste in a date, even though most of the values clearly aren't valid dates (which values Excel leaves alone). Other than writing a formula to figure ...
|
| Is there a way to trace changes made to a spreadsheet? | 30 Sep 2007 02:43 GMT | 5 |
We have been using Excel to hold our customer database. No one protected the or froze the document cells. A few weeks ago, someone sorted the information without highlighting the whole document, so now the names/addresses/phone numbers don't match up.
|
| Where can I find the Office Menu in Excel? | 30 Sep 2007 02:29 GMT | 1 |
I am trying to install PhStat on excel for statistics. I was modifying the security settings as it is required and I have to locate the Office Menu, and then click on Excel options. But I cannot seem to find it. These are the exact instructions:
|
| How to paste rows in 2007 without overwriting data? | 29 Sep 2007 23:06 GMT | 4 |
In 2003 version of Excel, one could highlight and copy rows from one worksheet to another. When pasting the rows using the insert rows command, the number of rows required to accommodate the data would be inserted and the existing data would move down. This was very handy for a ...
|