I have a timesheet in which only hours worked (hh:mm format)for each day are entered. 1. Is there a cell format that will allow the time to be entered either...

Using Excel (XP) text in cell B6 go to B14 and type =B6 the result is "=B6" and not the text of cell B6

I'm plagued by a problem where a simple solution likely exists, yet I can't seem to unearth it. I am trying to capture the count of a text string in one...

is it possible to filter out columns?

I have a spreadhseet withe names nad addresses I want to do a mailing to. THe list contains zipcodes I do not want to mail to. The list is too large for me to...

In row 5 I have a formula that retuns: Text, negative numbers, and positive numbers In row 10 I want a formula that I can copy across and if the cell in row 5...

Hi, In my Excel Macro, the User selects the file to open.I have used the following command. ExcelFile1 = Application.GetOpenFilename("Excel- files,*.xls",...

I was working in Excel on a completed spreadsheet, hiding some data preparing to do a mail merge. I had to close the program due to someone else using my...

How do you delete old links that do not exist in a current work sheet?

Columns of numeric grades are to be averaged, but teacher wants to choose where quarter averaging begins and ends. I want to just have them enter...

Hello: I have problem on how to calculate the daily average! Would you mind to give me some hints? Raw Data format! "Time","Free Megabytes" "08/01/2003...

I am using a workbook (30 worksheets), created by someone else, that contains macros (A message appears everytime I open the book that asks for me to enable or...

I am trying to sort a section of a worksheet which contains the values of other cells. i.e Cell C3 contains the value of Cell A1 (=A1) Cell C4 contains the...

"daredelsol" wrote in message ... Hello. I have two VLOOKUP formulas that give the...

Hi D2=IF(A2="","",IF(C2="G",B2,NOW())-A2) and copy it down as much as you do need. When the started call is closed, B-A is calculated; When the started call...

I am trying to find a formula to give a collum of "X"s,"Ph"s,and"*"s,a value of 1 for each, the collum is L6:L168 The total would show in cell L177 I don't...

I'm converting a spreadsheet from Works to Excel. I have two questions: 1) Is it possible to name the columns? e.g. name, date, etc. instead of...

I need to change the date format from 31/8/2003 to 8/31/2003. Could some one help? Under format, I tried changing it but it goes to an incorrect date. Paul

Hi All :-) I am trying to create a formula. A1=(B1*C1) OR (D1*E1) B2=(A2/C2) OR (D2/E2) C3=(A3/B3) OR (E3/D3) I wish firstly to lock cells A1,B2 & C3 as to...

How do I extract data from another worksheet with the same ID? E.g. (Column A will contain the ID and column B will contain the quantity) Worksheet 1 A5 -...