| Thread | Last Post | Replies |
|
| adding problem with formulas | 28 Oct 2006 04:29 GMT | 5 |
This may be just me spending too much time today in Excel, but I'm having a problem with what I think is a simple problem. I have multiple tabs in a spreadsheet, with tabs reading off of other tabs.
|
| comment has name & is bold | 28 Oct 2006 03:12 GMT | 3 |
Whenever I insert a comment it has a default format of boldface and my first name typed in. I don't want either. I want just a blank, normal format comment box. How can I get that? Thanks for any help,
|
| Macro runs when I click macro in tools dropdown | 27 Oct 2006 21:25 GMT | 1 |
Somehow I've assigned a macro that runs when I try to access all the macros from the dropdown box Tools, Macro, macros. How do I get rid of this so it goes back to its proper function? HELP!!
|
| Excel conversion to PDF? | 27 Oct 2006 21:17 GMT | 2 |
I have a huge text (several hundred pages) of Turkish in Excel format. Since some special characters are being dropped or altered when printing the Excel file, I need to convert the file into PDF to get a proper printout. Unfortunately, I am only able to convert on a page per page ...
|
| price list rounding | 27 Oct 2006 21:15 GMT | 1 |
I am able to adjust the whole range of prices by paste special multiply. Cant figure how to make the range round to the nearest whole dollar amount.
|
| DATE IN TEXT FORM - NEED TO CHANGE IT DATE FORM | 27 Oct 2006 20:34 GMT | 3 |
When I download data into excel some of the dates in the data comes as: 2Sep'06 I edit the cell by taking out the apostrophe and the value becomes a date. What formula / function can I use to take out or clean this apostrophe and make it a date? Thanks
|
| RoundUP formula | 27 Oct 2006 19:37 GMT | 2 |
Just need round up results of formula =0.15*E2 is this correct? =ROUNDUP(0.15*E2),2) thanks
|
| Simple graph | 27 Oct 2006 19:29 GMT | 2 |
I have a chart with zip codes and a population rate. ZIP RATE 80001 2.34 80002 1.23
|
| set toolbox optionbuttons | 27 Oct 2006 18:50 GMT | 1 |
I want to set some (control toolbox-) Optionbuttons in a worksheet to "True". I retrieve the names of which Optionbuttons I want to set from another sheet, and put those names into an array of Strings.
|
| SUM PRODUCT & CUMMULATIVE BALANCE | 27 Oct 2006 18:14 GMT | 3 |
I am able to use SUMPRODUCT to sum amounts based on dates as shown below: =SUMPRODUCT((sheet2!$C$2:$C$1000=C1)*(sheet2!$E$2:$E$1000)) Column C have the dates and Column E have the amounts How can I do cummulative balance using the SUMPRODUCT?
|
| Extract Value from another worksheet | 27 Oct 2006 18:06 GMT | 6 |
I have a work sheet that has parameters Mem1, Mem2 etc. I have another Worksheet ehich has the values for these parameters e.g. Mem_rom_234g for Mem 1 and so on. I am looking for an excel macro that can take the value of mem from
|
| Small 1-2 on worksheet's left in Excel | 27 Oct 2006 17:56 GMT | 2 |
I have a spreadsheet with several simple worksheets. In one of the worksheets, at the very left, there has appeared a small "1 2". Under that is a vertical line and a series of dots, one dot per row. At the end is a minus sign.
|
| Excel 2003 Crashing after a few hours | 27 Oct 2006 16:59 GMT | 3 |
As subject states, one of my users works in about 10 different spreadsheets all day long (5 of them are shared workbooks) and roughly every 3 hours excel says there has been a problem and will close and recover the spreadsheets. Sometimes it won't even give the warning message ...
|
| Multiple Excel Windows | 27 Oct 2006 16:31 GMT | 2 |
I have two screens. I'd like one spreadsheet on one screen, another on the other. Is this possible? To me, Excel does not behave like other programs, where different files can reside in its own, seperate window, like Word. Why, then, when I open
|
| Simple - does Col B exist in Col A? | 27 Oct 2006 15:14 GMT | 5 |
Simple question. I have a whole bunch of Names in Col A, like 500. I have 10 names in Col B. I want Col C to look at each entry in Col B and see if it exist anywhere in
|