Summary: I need to input a negative time value into a time formatted cell in excel. I have a cutom cell format: [hh]:mm;[Red] -[hh]:mm This works perfectly for...
Summary: I have created the excel file in excel 2003 and transfered it to excel 1997 in my 2nd computer. However when i tried to save the file in excel 1997, i...
Summary: I have a Parts spreadsheet that I want to be able to fill in the first column in a row, which is the part number, and then it automatically fills in t...
Summary: Hi, As I mentioned an alternative and more specific approach is to use a Macro. The following code can be attached to a command button on your summary...
Summary: I am using the Data-filter-Auto filter function to filter data based on 3 different criteria in Excel. Then I need to summarize one row of data. Thi...
Summary: Hi, From your post, I thought that you were familiar with conditional formating formulas, which is why I didn't provide any instructions for using it,...
Summary: Assuming your data is already sorted so that the duplicates follow one another as in your example, try this code: What it does is check each item in c...
Summary: Hi, I have a couple of questions: 1. What steps are you doing to merge the Excel data into Word. If I have 4159.68000000003 in a cell in Excel, but ...
Summary: Could some one please tell me how to construct a macro, in excel, to delete rows that in a collumn aren't multiples of 300. Thanks in advance ...
Summary: hi guys, i have this problem while doing excel. im not sure if this is do able, but if anyone got the solutions, i would be greatfull I need to copy s...
Summary: Hi, I need to calculate how many times 2 specific characters appear in the same cell throughout an entire spreadsheet of about 98 columns and 98 rows,...
Summary: I have created a spreadsheet which has a template form so that when information is added into an input sheet it links into the relevant section within...
Summary: Hi, You haven't said what values are in column B, but as you are using COUNT() which counts the number of cells containing a number (Excel help states...
Summary: Is there any way to assign a comment to a value instead of a cell? for instance have a name from a drop down list but when you hover over the name sho...
Summary: Hi, If you post the details someone will likely give you some code to get you started. Information required. 1. How many source workbooks. 2. What are...
Summary: Can somebody please help? I have limited VB knowledge and I am stuck trying to create a macro that reads a column of data starting column A (months) a...
Summary: Hi, This option uses a User Defined Function, written in Visual Basic. The cells containing the time must be formatted as Text. Before entering any ti...
Summary: Hi all, I would like to know which formula can I use to return the cell number if the citeria matched? e.g. A1 = 1 A2 = 2 A3 = 3 I would like to know ...
Summary: Hi, First a quick background on dates in Excel. Excel holds dates as numbers, starting with 1 for 01 January 1900 25 November 2009 is 40142 Excel also...
Summary: Hi, I don't think that you can create a format that adds a ',' within a number in places other than every 3 characters (thousands). If you are bringin...
Summary: Here's what I want to do: From: A B C I want it to become: A A (selected row) B B (selected row) C C (selected row) How do I do this? Here is my draft...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
