| Thread | Last Post | Replies |
|
| Time formatting hh:mm:ss | 21 May 2008 00:30 GMT | 6 |
Hi, all, I have data downloaded from a source that provides the time as 5-6 digits. E.g., 94423, 132218, etc. I want to show it as hh:mm:ss. So: 09:44:23, 13:22:18, etc. I've tried various
|
| How to auto add data based on value in another column | 21 May 2008 00:25 GMT | 5 |
Hi, I want to automatically add data in a column depending on the value of data in another column. For example, if column one has a value of 1,3,9 or 12 then a value of 1 is automatically entered in column 2; if column one has a value of 2,4,7,8 or 11 then a value of 2 is ...
|
| "Excel cannot complete this task with available resources" | 21 May 2008 00:24 GMT | 2 |
Occasionaly I ask Excel to bite off more than my PC can chew with a lot of calculations on some large complex spreadsheets. Is this a software or hardware limitation? Would multiple processors give an improved performance, a workstation?, supercomputer?, more memory? or does
|
| insert an extra row or collum | 21 May 2008 00:12 GMT | 2 |
Please send steps in order to tell me how to put in a row so column A becomes column be and column a can be used for another set of data. It will help me a lot if the steps are in a list and not in a paragraph. I would also be much obliged to have these steps as quickly as can be ...
|
| Nothing shows in formula bar! | 20 May 2008 23:35 GMT | 5 |
There is nothing showing in the formula bar when going to a cell with data in it; I can see the data on the sheet, but... The default font is automatic (black); I have no workbook template (using default); I have not changed Windows font in anyway; help! Thanks!
|
| If Statement | 20 May 2008 23:20 GMT | 4 |
I have written a formula IF(M15="L","X","") but I want to add to the formula IF(T15="BA","") Can anyone help me with this? Thanks!
|
| Strike-throughs and equations | 20 May 2008 23:09 GMT | 2 |
Hello people: I need some advice: When you have an equation to sum all the numbers of a column, is there some way that when you use a strike-through (part of the fonts), that the number that now has the strike-through can be not-included
|
| Fill Options for 2007 Excell Chart | 20 May 2008 22:39 GMT | 5 |
How can I get a bar chart to have lines or hatching? I only see the picture or texture option. thanks
|
| IF-more than 7 arguments | 20 May 2008 22:38 GMT | 3 |
The following formula is working perfectly but I now need to add one more test.... I need to check T14...if T14 is equal to the word "Forever" the result should be "0" and there should not be any more testing
|
| Adjust %'s across cells | 20 May 2008 22:36 GMT | 2 |
Hi all, I have 3 cells and have a total of 100% and want to enter in a % into one cell say 40%, from there that would leave me with 60%. IM trying to figure out how to change one cell and then have the 100% decrease so that I dont
|
| Sumif cells of a certain format | 20 May 2008 22:31 GMT | 3 |
I want to add cells that are all fomatted with the a certain cell color.
|
| Previously answered question | 20 May 2008 22:31 GMT | 3 |
I asked a question this AM and got an Email that it was answered, however I can't find the answer.
|
| Copy and Paste | 20 May 2008 22:02 GMT | 10 |
I have a master sheet that I copy to from another workbook. Sometimes it works fine and other times my sheet that I copy to crashes. Any ideas why coping and pasting could cash a crash?
|
| Is there a way to short this substitute formula? | 20 May 2008 21:39 GMT | 3 |
I want to remove all periods, hyphens and comma's. The below works but is there a better solution? =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(K35,".","")," ",""),"-","")
|
| Need command line to change the results in a cell from #DIV/0 to 0 | 20 May 2008 20:38 GMT | 4 |
What would be a command line to change the results in a cell from #DIV/0 to zero?
|