In Excel spreadsheet 2007, I have a column I want to enter figures like these: 5.00 4.90 5.25 etc. I enter the figure, leave the cell and it goes to 0 or to...

How do I make a rule that an identical number cannot be entered twice in an Excell column?

I wish to detect a signal in to an excel cell via a parallel port, hopefully I can then count the number of pulses over a period of time. Any help would be...

Here's what I have: A1 = .75 (that's point seventy-five, less than zero) B1 = the argument =IF(A10,A1,0) The result I get in B1 is 0 when it should get the...

See above.

I had no problems with MS Excel 2007 so far, and yesterdays my files saved OK, but today I found Excel can't open neither of my many spreadsheets created...

i have some VB code that i am going to use so that when a user closes the spreadsheet it saves the original "book" and saves a copy "Book1" the next time it...

I've got 2 worksheets, one labelled Data File and one labelled Lookup. The Lookup sheet is to be maintained by colleagues, as and when they go out on a visit...

I am charting monthly call volumes in a line graph in which I have 7 series (a different line of business). Each series takes 12 cells of data,...

Dear All, Can you have a look at this and please tell why it doesnt work Sub CopySheetAsHTML() Dim fName As String

I have a text file that I opened in excel and need to replace some of the data with new data. I cannot use the find/replace all function because the old...

Why does my formula =OR(O8"";H9"";1;0) display "TRUE" when cell O8 or H9 is empty? It should yield 0 (Zero). It also displays and "TRUE" when these...

I need to enter one date, and have it compute the future date based on the number of years: For Example: - Date Added: June 2007 - Number Of Years: 5 Year -...

I launch Excel 2003 then select tools/macro/visual basic editor. In the subsequent window, I click on "ThisWorkbook". In the properties window, both the...

I need 2 cells to multiply each other IF another cell is greater than 0. I need the entire column drafted for such a IF THEN formula. So for example column...

Hi, I am glad I have discovered this post, because I am new to excel and on a steep learning curve due to the requirements of my work. I have a large...

I need some help with links in my damn worksheets. I do not want any, ever, that I can imagine. I know how to make hotlinks into flat text, but I wonder is...

dear bill july-07, coll july-07 ,w/o jul-07 ,bill aug-07,coll aug-07,w/o aug-07 210 140 210 366 370 366 300 210 210 210 140 if bill for...

I have a very basic table/database (columns of data with a field name in the first row) on a sheet in one tab. How can I have other tabs which dynamically...