| Thread | Last Post | Replies |
|
| Formattinb cells | 17 Jan 2007 06:11 GMT | 4 |
Is it possible to change the background color of a column of cells depending on the value of the cell at the top of the column. I have written a macro to do this but can't find a statement to do this:
|
| Excel converts text to formulas %@#$ | 17 Jan 2007 01:42 GMT | 3 |
I wish Microsoft stopped developing "helpful" programs. All their "auto" stuff leads to nothing but problems. Here is an example: I have to process data which come as CSV files and contain entries that look like multiplication e.g "3*4". Damn Excel can't handle
|
| IE7 causes FILE ERROR:data may have been lost Excel 2000 | 16 Jan 2007 23:22 GMT | 4 |
After installing and uninstalling IE7 twice I cannot open a Excel documents without getting the error message and closes Excel, with this info. AppName: excel.exe AppVer: 9.0.0.8950 ModName: excel.exe
|
| Flipping order of contents of a cell based on a coma | 16 Jan 2007 20:55 GMT | 3 |
I have the following information in a column: VIGNEAULT, NATALIE A RYAN, BRANDON D HALLEY, ANDREA S
|
| Adding spaces between all characters in a cell | 16 Jan 2007 20:15 GMT | 3 |
I have a column of data that contains account numbers and they are always 7 characters long. Ex: 1125571
|
| hyperlink to adobe Pdf file | 16 Jan 2007 17:18 GMT | 1 |
I enter a hyperlingk to an Adobe Pdf file that is on my computer in a cell, but it does not open the file, it just gives a blink and nothing happens. I tried this link in Outlook and it worked, and I tried inserting hypelinks in excel to word and other programs and it worked fine ...
|
| Conditional formatting problem | 16 Jan 2007 17:09 GMT | 4 |
I am trying to put conditional formatting onto some cells in Excel 2002, so that if they return an error, the font color changes to white, effectively rendering the #VALUE! errors I've been getting in some cells invisible. I set the condition to ="ISERROR" and the font color
|
| Enable Mcros | 16 Jan 2007 16:42 GMT | 1 |
I have an application which uses Macros. If I try to run it I receive a message "Enable Macros". How do I do this? Thanks Kalevi
|
| Opening templates made by excel 7 | 16 Jan 2007 16:03 GMT | 1 |
I am trying to download and open new files from MS template library. They are in .XLTx ending format. 2003 excel cant opening these files. How do I get around this? Dr
|
| Bar Graph | 16 Jan 2007 15:57 GMT | 5 |
I need some help. I have a bar graph that has values ranging from 98% to 4%. My boss would like me to show the garph maximum value at 10%. He want to show all bar but at the ones above the 10% he would like to show a break in the bar and then show the % at the top. He says he ...
|
| Basic IF function help | 16 Jan 2007 15:32 GMT | 2 |
i am new to excel and trying to use the IF function. i am trying to figure out how to get excel to only display the result of the formula is a number. in some cases, the formula has "0" in numerator so i get "Div/0" answer. in that case, i want the result to display just a
|
| Clustered bar chart - bars not touching | 16 Jan 2007 15:17 GMT | 1 |
Hi - I posted a question last week that no-one has answered, either its impossible to do or I didn't phrase it properly! Re: Clustered bar chart I have monthly data ranges with 5 possible values, eg May has 5 sales
|
| How do I do a cost comparison of products from many vendors? | 16 Jan 2007 12:15 GMT | 1 |
I have a list of about 50 different products that I want to compare different vendor's costs. There are about five vendors total.
|
| Auto assigning | 16 Jan 2007 09:36 GMT | 1 |
I have 7 columns, they are Date - Req. Number - Requestor - Dept. - Notes - IOU,Yes/No - Status The departments have a req. number assigned to that dept for trackin and I have sorted the sheet to keep the depts. together. The dat
|
| how do you use macros??? | 16 Jan 2007 09:03 GMT | 3 |
how do you use macros. we kinda need it for our ICT coursework... pl help if u can thx -- aly
|