I need help with a formula. In Column B I will have a date. In column E I will have a total of C and D. Right now, in E I am using =SUM(C3+D3). If I do not...

When I export a table from a third party application into an Excel file, formulae are not calculated. The formulae are displayed instead of the value of the...

Please help…. What is the formula to convert 1.0 days into 8.0 hours???? Thank you in advance

Hi I have extracted data from 2 reports and merge the data in the 3rd report. Here are the report formats Report 1: ...

Is this site faulty? Can some e-mail me . Remove the 1234a Thanks Stew

Is there something wrong with this site? I posted last Friday and I received some answers. They now disappeared and I'm not allowed to view even my post.

I have a large workbook (14MB) that contains 3 months of 1 minute data in three tabs that is cut and pasted from another spreadsheet that does the...

Hello all, I have an Excel file that retrieves the data from an Access database via query. As you all know, once a query is created, a define name is...

While attempting to use the SEND E-MAIL function in both WORD and EXCEL I will receive the "General Mail failure...and restart" note. As reported by others...

need a formula if less than 100,000.00 multiply by 10% if over 100,000.00 multiply by 20%

I am facing a strange issue with using some excel 2003 files in excel 2007. When the file is saved as .xls/.xlsm format in excel 2007 and re-opened again,...

Hi All, In cell A1 I have, say, 30-Nov-08. In cell B1 I want a formula to return the last day of the last month end i.e. 31-Oct-08. In cell C1 I want...

Excel 2007 The icons in the Quick Access Toolbar are small and very difficult for me to see. Is there a setting that would enlarge them? Thanks in...

I'm trying to create a formula wich allowes me to use abbreviations for company names and their credit number. Something like: If I put "st" in a cell, the...

Is there any shortkey for center the text & merge the Cell in excel -- Regards,

how do I add a page within the worksheet

I am referencing a cell which has 1 decimal place yet it shows about 12 places right of the decimal in the string. What am I doing wrong?

Dear Excel(lent) users, I have a challenge, which I would like to share with you: I am managing multiple projects and have multiple teams working on these...

I am wondering how I can input data into Microsoft Excel so that it can be read as a CSV file format. I am a teacher, and I am trying to create a test bank...

Yes well, I posted four times only to discover that when people reply, the messages cannot be read. For those of you who tried to help, thank you. For the...