| Thread | Last Post | Replies |
|
| My results don't appear in the cell | 16 May 2005 08:11 GMT | 8 |
I am using a Sum IF(ISTEXT)) formula. I already know the formula is correct because the results appear correctly in the Function Arguments pop-up box. However, I can't get the results to appear in the cell. Help!!!!
|
| month, year as date | 16 May 2005 06:41 GMT | 2 |
Hi Is there a way of formatting date to only show date as month year, (May 05). Using excel 2003. Thanks TIm
|
| hide 0 values in pivot table (2003) | 16 May 2005 03:24 GMT | 1 |
Hi I can not find how to hide 0 fields in pivot table in office 2003. thanks tim
|
| LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. | 15 May 2005 23:43 GMT | 1 |
I am having a problem with one of my spreadsheets for my GNVQ I.T. coursework. Please help! My spreadsheet is for a boat hire company. On one table is a list of the boats, times to hire the boats and the cost to hire the boat for that amount
|
| CUSTOM FILL USING DATES | 15 May 2005 22:13 GMT | 2 |
I want to fill a col using "tue, wed, thu, fri, and sat" using the dates not the text. I want to fill Col. A for one year with Tuesday through Saturday's DATES only. Col A:
|
| Attempting Excel Template | 15 May 2005 21:46 GMT | 3 |
Very new to Excel and having trouble with columns. Have searched Help and Templates but can't seem to find what I want. I need 4 columns of various widths in the upper portion (row 1 - 19 for name, address and other info) and 6 columns of varying widths different
|
| export a single row to word | 15 May 2005 21:32 GMT | 1 |
Is it possible to export a single row of information from Excel to Word. Or Is it posible to export multiple rows of information from Excel to Word where the rows must appear as separate lines of information within a single
|
| Creating a form using a spreadsheet | 15 May 2005 20:43 GMT | 2 |
Does anyone know how I can use a spreadsheet to populate fields in a form?
|
| #value! | 15 May 2005 19:49 GMT | 6 |
In a1 I have alink to a cell on another page in the workbook. In b1 the formula a1/100. When I edit the cell ref in a1, b1 returns #value! I don't understand why, and I can't seem to do anything about it.
|
| Updating a league table | 15 May 2005 12:09 GMT | 1 |
Hi guys. I'm trying to teach myself to use excel and as a project to get me going I've decided to create a results and league table for the English Football Premier League. I've got my fixtures and result grid, and the league table. I've programmed
|
| Getting rid of annoying paintbrush icon | 15 May 2005 11:41 GMT | 2 |
Ok, I give up, I have looked all through the program options... HOW does one turn off that stupid and annoying paintbrush icon that comes up on the screen and COVERS UP (!!!!!) what you are trying to work on? Arghh!! Is it ONLY Microsoft that has programmers that come up with ...
|
| Form-filling application with Excel (background image)? | 15 May 2005 08:40 GMT | 1 |
Is there a way to place a background image on a sheet and print the damn thing as well? When I set the image as a sheet background, it won't print. I need this to create a form-filling application, where I place a scanned
|
| Wierd Issue, can't deselect anything in Excel | 14 May 2005 23:52 GMT | 2 |
Running Excel 2002 on Windows XP and have this wierd issue. Whenever I open Excel directly or by opening an Excel file, once I click anywhere in that spreadsheet, the cursor acts like the left mouse button is stuck down and will only select objects. No matter what key ...
|
| Limit workbook size | 14 May 2005 20:10 GMT | 2 |
Can someone please remind me how to limit the size of a sheet? I dont need anything past V:30 Thanks, Rick
|
| Histogram data analysis tool | 14 May 2005 19:39 GMT | 10 |
In attempting to use the Data Analysis Tool histogram generator of Excel 2003, I can't get it to work right (i.e., the way I want it to work). I suspect that I have some sort of DATE HHMMSS problem, and one confusing
|