General
in [Excel]
|
Algebraic Functions How would you solve a function with input 1 output 8. Then input 2 output 14. next input 3 output is blank then input is blank Output is 24. the input is blank and the out put is 28. Finally, the input is 6 and the output is blank. ... 27 May 2010 15:58
Formatting Text to Numbers for Dates Tommy, I assume the date you meant was 21/06/2010 and that the format is dd/mm/yyyy. If so, use this formula to turn it into a date: =DATE(RIGHT(A1,4),MID(A1,4,2),LEFT(A1,2)) This should return a number. Then format the cell as a date. HTH. "Tommy" wrote: I'm currently working with a column of d... 27 May 2010 15:58
DEFAULT ITERATION - HELP NEEDED I would include a macro that runs automatically when your workbook is opened. The macro would save the state of iteration and then setup iteration according to your model's needs. Another macro would run automatically when the workbook is closed. The second macro would restore the state of iteration. -- G... 27 May 2010 18:11
How to access macros via tool buttons? Excel v2007 When using v2003, I had many macros In my Personal.xls, which I accessed via custom tool buttons on many custom toolbars that I built. I now have version 2007, which includes my old Personal.xls with all my macros, but I want the easy access to those macros I used to have. Being the tool ribbon is a ... 27 May 2010 11:31
Office Professional Xp user buys a Mac Hi, Will I be able to open and use any/all files created using my Office professional XP suite (2002), in a new Mac with the latest version of Office available for the Mac? ... 2 Jun 2010 20:56
cross-hares Back in the day, when you selected a cell, you were able to have a line appear vertical and horizontal I believe with your curser. It looked like cross-hares. That way, you would easily see the row or column you were in. How are you able to do that now in 2007? ... 27 May 2010 18:11
Two values not adding correctly In Excel 2003 and 2007, why, when adding 664,199.05 and negative 582,911.61 the answer comes out 81,287.4400000001? Why is there a 1 at the end? This causes issues when building formulas to control two sets of information that should equal one another. ... 27 May 2010 17:04
Sumproduct - Return value as Blank Hi I am using the sumproduct formula below to pull information from one work sheet to another. However some of the values in the range ranking order E5:E38 are blank. The rest are 0% to 100%. I need to get my formula to return blank instead of Zero unless the value in col E actually is Zero. I have tried IF on... 27 May 2010 22:33
Programmable Column Sequencing? I am currently using Excel 2003 and 2007 if necessary. I would like the ability to configure the excel sheet column sequencing when I hit the enter key or tab key. Is this possible?? Any suggestions??? Thank You, G ... 27 May 2010 17:04 |