General

Solver with binary variable
Hello everyone! I still got a problem with a Solver optimization. I hope you can help me. There is a machine which can produce 2 products separately. In my optimization problem there are several constraints: - Sum of Production of X & Y is equal to or less than capacity of the machine - Demand of X & Y must... 22 Dec 2009 05:59

ZIP codes
Hi, How do I insure that when I enter the zip code in a cell or group of cells that the zero shows at the start? Thanks. ... 21 Dec 2009 20:17

Excel 2007 Paste Values-Text Only (Always)
In Excel 2003 it was possible to customize the Paste Values button and select "Text Only (Always)". Once customized, the button appeared as "Paste Values" (P underlined) in the toolbar window. Used in conjuntion with Ctrl-C, this functioned as a shortcut key (Alt-P) saving much time and without having to utiliz... 21 Dec 2009 13:34

Lookups?
I'm trying to create a formula that will lookup the what is in column G in column B of another sheet. If what is in column G is in column B of the other sheet, the word NEW is returned, otherwise the cell is left blank (""). Any help? Thanks! ... 21 Dec 2009 11:17

2007 Excel file formats
I have a sheet with a user defined function that will run fine in 2003 however when it is opened in 2007 the function only returns a "#NAME?" error. Is this a file format issue or something else? Any help would be appreciated. ... 21 Dec 2009 10:11

@ symbol in field
Excel 2007. I need to have some cells with a @ character at the start of them. As soon as I add it and move out of the cells it gives me a "function not valid" error. I have tried turning off all sorts of autocorrect and other options to no avail. How can I get that to stop trying to change it and leave it ... 20 Dec 2009 12:31

Excel 2007: Can it SUMIF( ) using color as a condition ?
Hi, I understand that Excel 2007 can sort by colors. It is a great feature indeed. May I know if =SUMIF( ) could use a color as the condition to sum up color shaded cells or cells with certain font color? Thanks Low ... 13 Jan 2010 08:44

Excel attachment in Outlook causing 2nd instance of Excel to open- help!
I just reinstalled ofc2003 on a win xp system and now for some reason when I open an excel attachment in outlook my computer opens a second instance of excel. (I already have excel open before clicking on the outlook attachment.) The only slightly different thing I have going on is that I have all my programs o... 18 Dec 2009 15:02

Row Height-Auto Adjust to Content?
Hi everyone, Is it possible to set Excel Rows to automatically adjust to the content in any rows? I'm working on a significantly large excel sheet and prefer to print only one sheet of paper across; however I'm trying to squeeze a couple more columns in there that might overflow to the next sheet across. I'... 21 Dec 2009 19:11

How do I disable the advanced printing features permanently?
Everytime I print an document, the information comes out backwards (mirror image) of what I entered. I've tried disabling the Advanced Printing Features but it always defaults to mirror image. ... 17 Dec 2009 20:26