Dear all, In a cell, I type a sentence combining text and a date. However, the date turns out a value instead of current date. ="The profit of selling...

Help- someone said it does not go away!! How do i recover from line 180 to 200+

Hi, I think I have been asked to do the impossible. I need to write a macro that will give me a matrix of 20 names over 6 days. There will be 2 groups of 10....

Hello, I have an Excel sheet which has macro's written as well as Calendar control used. This sheet was developed in Excel 97 (windows 98) environment. It...

Dear all, I've a problem with date when I input a cell with text and a date. I input: ="The profit of selling tickets as at" & NOW() Return: =The profit of...

I need to be able to look up a value from 1 cell in a range of cells to find if there is a match and where the match is Can anybody help Thanks Donna

hello all! How do I solve the below equation in excel? + + + + = 0 Thanks! Kunal

When inserting rows, is there a way to autofill data from the row above or below? I have a simple autosum formula on each row -- if I insert another row, I'd...

I have a pretty elaborate workbook set up that is keeping track of my inventory, sales, production, etc.... My problem is that I share this workbook w/ 2 of...

I have a lookup formula working just fine as long as what I want it to look up is there. My problem is that when the number I want it to look for is not on...

I have a huge file but with only 2 column. Column A is the serial number and column B is description. I need to combined the all description that has the same...

Ken- thanks for solving my original problem. One follow up question. If I put a standard formula in A1 say =A2+B2, I can drag that to the cells below and it...

Having created a macro in a spreadsheet using Windows Office Excel XP, I send it via email to my office, to continue working on it, & macro will not run (at...

I am working on a report where I am trying to show the amount of time that passed between when we received a completed contract and when the installlation...

Dear All, Please suggest me the solution of my problem, as i m handling data for 60,000 in no.Some body in data entry has enter the date in a cell in gernal...

In Excel Xp how do I get a cell to show the sheet name,alternatively can I get the sheet name to show the contents of a cell.

Is there a way (or formula) to generate a random number in a cell? If so, can I specify the range I want the random number to fall into, e.g., 1 through 6, 0...

I have a list of around 1000 names, separated into first name in one cell, and surname in the next, with an employee number in the third. I need to create a...

I would like to concatenate some cells where the result will be the first letter of one cell and the whole word of the second cell. John + Smith = jsmith. Is...

Thank you very much. It was very helpful. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post...