| Thread | Last Post | Replies |
|
| Beta 2 Technical Refresh | 29 Sep 2006 19:43 GMT | 2 |
Hi, I have just loaded the Tecnical Refresh for MS Office Beta 2, however when I try to open any spreadsheets (predominantly MS Office 2003 versions) they get blocked by anti virus software - presumably linked to the Technical refresh. These spreadsheets were accessable prior to ...
|
| i have a pps file that i cant open what do i need to open it with | 29 Sep 2006 19:05 GMT | 1 |
i recieved a few pitures and cant open then because they are a pps file what do i need to open them with????
|
| Formula Problem | 29 Sep 2006 19:03 GMT | 3 |
I have an excel sheet that has almost 4000 data rows. I need to compare the old sheet to the new sheet and if the part number is equal, I need it to show me the discount from the old sheet in a column in the new sheet. Here is the formula I came up with: =LOOKUP(A4,old!A4:A4000 ...
|
| Rounding of amounts | 29 Sep 2006 19:02 GMT | 12 |
I have a small retail store and am currently working on price changes. I have an excel with all the calculated prices however I would like to round all amounts to xx.x9. The 2nd decimal should always be 9. Is there a way to do this in Excel? I checked the help file for anything
|
| i don't want to enter dublication data at a column | 29 Sep 2006 19:00 GMT | 1 |
i don't want to enter dublication data at a column
|
| Calculate Rate of Change Formula | 29 Sep 2006 18:03 GMT | 6 |
Could someone help me w/the rate of chage formula to use when going from a Negative to a Positive number and visa versa In the column below - and + #s followinf each other So what formula should I use to figure out ROC between 1 & 2, then between
|
| Run-time error 424, Object required | 29 Sep 2006 16:10 GMT | 6 |
I have the following code: sub foo() dim record as range set record = Range("A" & ActiveCell.row & ":K" & ActiveCell.row)
|
| Excel 2003, when I click on a particular cell it gets deselected | 29 Sep 2006 15:41 GMT | 1 |
While using Excel 2003, when I click on a particular cell, within 30 seconds, that particular cell gets deselected followed by the workbook. So each time I need to click either the cell or workbook to enter data in that particular sheet.
|
| Replace with Macros | 29 Sep 2006 15:10 GMT | 2 |
I need to replace the "," by a "." in many cells to fit another country decimal separation. My regional parameters use normally ",". When I do it into Excel with the replace function it is ok and produce the macro script :
|
| How can I check a cell for current date and insert it if blank? | 29 Sep 2006 14:46 GMT | 3 |
I am modifying the invoice template. I want to create a formaula that checks the date cell for the current date. If a date occupies the cell nothing happens, otherwise, the current date is inserted. Can this be done? Thanks
|
| formula with letters and numbers | 29 Sep 2006 14:26 GMT | 1 |
Excell 2000 or Excell 2003 can a formula be set up to use letters and numbers like V2 to record in column for v the number 2 if the input is v4 the number would be 4 and in the same cell the combination of T3 could be entered and in the column for t would record 3.
|
| Compare cell contents | 29 Sep 2006 11:48 GMT | 2 |
I want to check if two cells do contain the same text, e.g. the same country name. In case there is a difference I want to highlight the first cell with color red. something like that. I tried Conditional Formatting but it seems that the IF function only works for numbers, and not ...
|
| Macro/Database question | 29 Sep 2006 10:25 GMT | 1 |
I am using a macro to connect to the database and update a stored procedure. I am able to disconnect the excel sheet from the database manually by going to "data" in the menu, then "import external data", then "data range properties", and unchecking "save query definition" in
|
| Fx does not work? | 29 Sep 2006 07:36 GMT | 4 |
I have copied this formula to an other workbook, but I keep getting #NUMBER as a message? I have copied the original several times bu cannot get it working? Thanks
|
| A complete novice guide to excell which course is best to start | 29 Sep 2006 02:42 GMT | 1 |
Not sure which one is best to start with Is there one for works excell which would be easier to start with
|