| Thread | Last Post | Replies |
|
| Pull Members' Race Times from a Database? | 08 Apr 2007 02:24 GMT | 4 |
Please help: Sheet 1 is a spreadsheet with 1/2 marathon race results. Column A has all the names (Last and first in the same cell, sorted alphabetically by last name). Column K has the finishing times.
|
| copy and paste | 08 Apr 2007 02:08 GMT | 1 |
I am trying to copy and paste a worksheet in an email. I cannot get the gridlines to show up in the email. The data is there, but not the lines. Do anyone know how
|
| Cells formatted with "("@")" don't change when text pasted in (?). | 07 Apr 2007 23:15 GMT | 2 |
I have a column in a targert spreadsheet formatted with "("@")". When I paste values from the working spreadsheet into this final, presentation one, the formatting doesn't take until I manually re-type the numbers in. I'd like to save all that work, if possible.
|
| Series including text possible? | 07 Apr 2007 22:41 GMT | 3 |
Is there a better way to create a "series" that is based on characters as well as digits than what I'm doing below? I created 3 columns. I put the text in one, the digits in the second that I could apply the series to, with the 3rd column holding a ":".
|
| find replace VBA | 07 Apr 2007 21:09 GMT | 10 |
I have a list of addresses that I want to standardize. For example, I have this list in column A: 100 Randlett Steet 450 Park Str
|
| Validation of "Petty Cash" | 07 Apr 2007 20:33 GMT | 3 |
I have a column where the entries will be either of the following four: Petty Cash LPOnnnn
|
| Formulas inserting from nowhere?? | 07 Apr 2007 18:55 GMT | 8 |
I'm working on a spreadsheet that I got from someone else (who got it elsewhere originally, so they don't know the answer either). I type a value in a cell and other cells automatically calculate. No big deal - except there are no formulas in those cells until I type a value in
|
| Correcting date format? | 07 Apr 2007 16:48 GMT | 1 |
I found some data that I needed to add to a spreadsheet that had dates in a format I don't use, though it's a standard one in Excel of mm/dd/yyyy. I first saved the data in a text file so even though it came off the web, the text files converted the data to plain text
|
| Addresses | 07 Apr 2007 15:48 GMT | 2 |
Can anyone please advise me how i can insert a name and address from the microsoft address book into a exel spreadsheet. If this cannot be done what alternitives are there? Thanks
|
| Two Formats for One Cell | 07 Apr 2007 14:34 GMT | 1 |
Is it possible to have two formats in one cell. I have a column in which dates or decimal points will need to be keyed (ex. 20070301 or 0.00)? -- Ivy
|
| Number of rows in Excel 2007 | 07 Apr 2007 14:00 GMT | 2 |
Hi everyone, I was under the impression that Excel 2007 was going to have more than 1 million rows and 16,000 columns. I opened the program last week at work and saw only the regular 65,536 just like previous versions. Am I dreaming, did I invent in my own mind?
|
| How to programmatically set a focus on the selected cell? | 07 Apr 2007 13:56 GMT | 8 |
Using Excel automation, how to set a focus (rectangle around the cell) , by specifying Column No and Row No.? Thanks, Jack
|
| Dynamic 12 months data on the chart | 07 Apr 2007 13:32 GMT | 2 |
I have the following data on worksheet 5 for example and is arranged like this: Date ...........Nov'06 Dec'06 Jan'07 Feb'07 Mar'07 Apr'07 May'07
|
| Some fields show with their field names, others with F11, F12 etc | 07 Apr 2007 06:20 GMT | 1 |
I am at the 'insert mail merge' step in Word 2003. I have my fields in the top row of my XL 2003 sheet. Some of the fields are text, others are dates, others are blank. I just need the text fields to show in the list (after pressing the 'insert mail merge' button. The first few ...
|
| Shortcut CTRL - PAGE UP/ DOWN won't work on protected sheets | 07 Apr 2007 04:28 GMT | 3 |
CTRL-PAGE UP / DOWN is to move from one sheet to another. Unfortunately it doesn't help after I entered a protected sheet. There is one case about this issue in Feb 2006. http://groups.google.com/group/microsoft.public ...
|