| Thread | Last Post | Replies |
|
| Formulas returning a blank if no data entered in one cell | 31 Mar 2005 16:37 GMT | 3 |
Very new to all this! I want to set up cells showing a percentage difference. I've figured out how to get it to do that but want to have a blank cell if no data has been entered into one of the other cells i.e price before increase = A, price after increase = B and C = % diff. If ...
|
| How do I Set up a Invoice in Microsoft Office 2000 Professional (. | 31 Mar 2005 14:45 GMT | 1 |
How do I Set up a Invoice Formate Template in Microsoft Office 2000 Professional (Excel) With detailed one (Rate, qty,Discount,Total,Tax)
|
| Empty Pivot Field using a Macro | 31 Mar 2005 14:13 GMT | 1 |
although I tried a couple of options, I do not seem to sucseed in making a macro which actualy empties the PivotField as I want to. I tried: ActiveSheet.PivotTables("PivotTable3").PivotFields("Count of Uren"). _
|
| Open Hyperlink without Confirmation Message? | 31 Mar 2005 13:17 GMT | 1 |
Excel 2003 insists on opening a "Microsoft Office" message box whenever a hyperlink that opens an external file (.mpg in this case) is clicked: "Opening xxxx.... some files can contain blah blah blah. Would you like to open this file?"
|
| How can get Microsoft Excel on to my p.c | 31 Mar 2005 12:05 GMT | 4 |
Could someone help me as i do not have a clue as what i need to do all i have been told is that i need Excel to beable to do my spreadsheets. HELP!!!
|
| Counting the number of coloured cells | 31 Mar 2005 09:37 GMT | 2 |
I would love to be able to count the number of cells in a row that are coloured yellow or the number of cells that are coloured green. Is this possible? Mat
|
| Excel Database | 31 Mar 2005 09:22 GMT | 1 |
I have a database I need to split equally in half by selecting every other lead. Is there a quick way to Select the odd numbered rows(or even numbered rows) of data(each row comprises one lead with it's info) cut those selected rows and then paste them to a new workbook, and ...
|
| Page numbering - multiple tabs | 31 Mar 2005 07:54 GMT | 6 |
I have a workbook that has three tabs. I update the workbook throughout the month, adding the previous day's data, analysis, and comments to what is already there. I print the entire workbook each day and distribute hard copies throughout the organization. I need to have all ...
|
| Formatig cells | 31 Mar 2005 07:06 GMT | 2 |
I created 50 similar TextBoxes containing numbers 1 to 50 with certain color. I wan to assign macrs to each TexBox so that: 1- copy the number inside the textbox to another cell (say D100)
|
| MAXIMUM NUMBERS IN CELL | 31 Mar 2005 05:15 GMT | 1 |
When entering more than 15 numbers in a cell, Exel automatically changes the integers after 15 to a zero. Example: 123456789123456789 entered into cell returns 123456789123456000.
|
| highlights | 31 Mar 2005 03:23 GMT | 1 |
Can you help me and tell me if this is at all possible using conditional formatting or a formula I4 is to equal to b4 times c4. If d4 is not the same as i4 then d4 needs to highlight in red. However if d4 is a negative number then d4 should remain
|
| Cell format switches to TEXT | 31 Mar 2005 03:02 GMT | 1 |
Whenever I edit a cell it changes format to TEXT. Then I have to set the cell format back to GENERAL, type a CR in the formula bar, and then I see my calculations. This is only happening in one workbook so there's something fishy about it's properties. Is there a default cell
|
| Filter (do not want the ugly drop-down button) | 31 Mar 2005 01:12 GMT | 3 |
ExcelXP I created a chart that has a column of dates. Every week I send out the chart and filter the column to just show one date. The drop-down button appears next to all of the columns. I just want the results without the ugly
|
| Excel things my spreadsheet is much bigger than it is | 31 Mar 2005 01:02 GMT | 7 |
I'm having a problem with certain spreadsheets where if I do a ctrl-end to go to the end of the sheet, I am taken much further than I should be if it were only going based on blank cels. Even if I do a "clean contents" for that cel, or delete the entire row, I still get taken
|
| How do I convert Excel 2003 to Excel 98 format? | 31 Mar 2005 00:48 GMT | 8 |
How can I convert an Excel 2003 spreadsheet to an Excel '98 format?
|