| Thread | Last Post | Replies |
|
| Request | 05 Jan 2007 07:11 GMT | 1 |
Are there any templates for various kinds of puzzles or ticket projects such as lottery? Thanks Barry
|
| monies spent and monies recieved | 05 Jan 2007 04:59 GMT | 5 |
Good day I have Excel 2007. What I am looking for is a simple spreadsheet which I can use for my part time business (photography). Monies recieved and then also a seperate column for all expenses (costs).
|
| Text to Column Function Rejects Zeros | 05 Jan 2007 04:07 GMT | 4 |
As part of a project, I was conducting a survey (administered online) using Snap survey software. Snap automatically sends results into an Excel file, which is great. However, several of the questions allowed participants to select more than one item ("Check the top 3 things..." ...
|
| Problem with functions working | 05 Jan 2007 03:11 GMT | 2 |
I seem to be having trouble with my functions. I type in the functio and it isn't showing the result - just the formula. For example I tried to concatenate: =CONCATENATE(A3,B3,C3,D3) This was created using the wizard. So I'm pretty sure it is correct.
|
| Formula for a fill color help | 05 Jan 2007 03:08 GMT | 3 |
I can't figure out how to make a formula that will recognize a color a a value. More specifically; If b1 is made to be green (color index 4) would like c1 to insert the letter Y. I am I'm looking for an I statement so I can use it throughout the whole workbook.
|
| Pasted formula doesn't work unless "re-initialized" | 05 Jan 2007 01:37 GMT | 7 |
I'll apologize in advance if this has already been answered but I couldn't come up with a search phrase to find an answer. I have an existing worksheet which I have been using successfully for all of 2006 but now I want to add rows for 2007. Whether I copy and paste, or drag
|
| Bug Rep: Excel 2007 .xlsm file not saving commented codes | 04 Jan 2007 21:50 GMT | 7 |
since i've tested this agaist 2 different copies of Excel 2007 fresh install on different machines at home, i think it's clearly a bug. ok, in order to save vba codes now in excel 2007, i'd have to save files in the .xlsm format. that's cool. everything been working sweet, until ...
|
| Dynamic Chart title | 04 Jan 2007 21:36 GMT | 2 |
I want my chart title to display the value entered in a cell. A2="Date". I did a right click on the chart options and entered =A2 in the chart title box. However, on clicking "OK", the chart title displays the "=A2" instead of the value enterd in cell A2.
|
| Repost: Index Match lookup formula returns #N/A error | 04 Jan 2007 21:10 GMT | 2 |
I have a file A with a list of item numbers in column A and corresponding quantities in column B. The item numbers in file A were imported as a text field, the quantity field type is number. In file B I have the same information, which I typed in by hand.
|
| date function | 04 Jan 2007 20:58 GMT | 4 |
I have a cell A1 with date 5/2/07. If in cell A2 I do month(A1), I get 5. Is there a way to return May instead? either through a command or formatting? I can reference cell A2 with the 5 with a if(cell = 5, "May", ) in cell A3, but the date in cell A1 varies from Jan to Dec ...
|
| 2 protected cells | 04 Jan 2007 20:33 GMT | 2 |
We suddenly have 2 more protected cells on the 12th page of our book. I have tried all kinds of things to drop the protection of these 2 cells. I have tried all kinds of things & looked @ help but no banana. Help. TIA
|
| cell, which should display for ex: Jan 1 To Jan 5. | 04 Jan 2007 20:31 GMT | 1 |
I have a cell, which should display for ex: Jan 1 To Jan 5. I am confused, as how to incorporate this both the text and the day of the date in the above format. Please help.
|
| Columns have changed from letters to numbers | 04 Jan 2007 20:20 GMT | 4 |
There's got to be a quick and easy answer to this problem. Somehow the column designations on our Financial Secretary's computer have all changed to numbers instead of letters. It was probably an accidental few keystrokes or mouse clicks that did it. It makes it quite ...
|
| Excel 2003 prompts to save or overwrite | 04 Jan 2007 20:18 GMT | 1 |
I have a few excel 2003 users that have xls files on a server, but they are the only ones using. Often, when they save, it tells them someone else may have changed the file, rename or overwrite. They are a bit concerned, It appears to be a mac services thing, I found the ...
|
| Cell should calculate the date of monday | 04 Jan 2007 19:45 GMT | 3 |
I want to know if a cell can calculate the date for the first monday of every month. Regards, Navin
|