General

How to remove automatic calculate function?
My excel always 'calculates' even when I am only typing a word or just a number. There are no filters or formulae, it happens when I just open a new book. How do I avoid this? ... 29 Apr 2010 08:59

Be Careful while dealing with dynamic type and System.DBNull in C# 4.0(beta)
C# 4.0: Provides many new, useful and powerful features. One of those is "dynamic" type. "You can have a number of references with search keyword [Dynamic Type: C# 4.0 ]. I love to use it. I was facing a particular situation while executing sql statement (particulary returning a scalar value) and then returning the... 29 Apr 2010 02:25

Be Careful while dealing with dynamic type and System.DBNull in C# 4.0(beta)
C# 4.0: Provides many new, useful and powerful features. One of those is "dynamic" type. "You can have a number of references with search keyword [Dynamic Type: C# 4.0 ]. I love to use it. I was facing a particular situation while executing sql statement (particulary returning a scalar value) and then returning the... 29 Apr 2010 02:25

How do I set expiry document dates on Excel 2003?
... 29 Apr 2010 08:59

how dose filter works to last cell in the column
some time fillter do not show existing cells ... 29 Apr 2010 08:59

Adding fractions and displaying as Percentages
Hi, I have a question. I am stuck with I am trying to add a number of Fractions and then Display as a Percentage. Does anyone have a formula for this that works? 4/4 4/4 3/3 2/2 2/2 = 100% 4/4 4/4 3/4 2/2 2/2 = 94% ? Is there a way that excel can automatically calculate this? Thanks heaps ... 29 Apr 2010 02:25

How to hide a formula and display something else?
I have a cell with a PV function and I want to know how to leave that function active in that same cell but I want to only have the words "PV" be visible in cell. How can I do that? ... 29 Apr 2010 01:20

Sorting Project that Requires Math Skills
Dear Math People: I have an Excel sheet of 120 pages, with 5 cards on each page with a total of 600 cards. I am going to Office Max where they will make a total of 5 cuts. I need to figure out how to sort my cards (they are numbered 1-600 accordingly) so that when they make the cuts and then stack the 5 piles o... 29 Apr 2010 08:59

Countif formula
Excel 2002 =COUNTIF(Data,"*9*") This will return the number of cells in the range named Data that contain a 9. How can I make this formula refer to a cell instead of using the desired number in the formula. Say I have a drop down list in G1, if I select 4 then the formula should return the number of cells... 28 Apr 2010 20:53

Shortcut to Excel file doesn't 'work' any more...
Suddenly, after this past weekend (when ostencibly no one was in the office), a client who uses Office 2007 Pro on her XP Pro machine has had a strange 'issue' with several 'shortcuts' to specific Excel worksheets on their server... Where once she could simply 'double-click' on the desktop shortcut to this fil... 28 Apr 2010 19:45